Great video Ed.I hope everyone takes the time to watch it. It will make macro believers out of them.
Have you used free iMacro for Firefox? I have been coding most of my macros in it for blog creation and email activation.
Here is another example where sharing only strengthens a team.
What's really important as you noted is organizing your data so that it can easily be shared among your different tools.
The biggest part of automation is not how fast a macro can run but how far you can make one data file go without reformatting it. A master data file that can be used for 3 different blog platforms reduces two thirds of the setup time.
Thanks again Ed.