On Fri, 14 Jul 2006 07:55:02 -0700, Gradnama
wrote:

Thanks Steve. While your post gave me hope that it can be done,
unfortunately it also gave me a benchmark of where I need to be--I understood
very little of what you wrote. I guess I'll start trying to learn VBA!

Thanks for your help. If you have any great suggestions of the "best ways"
to learn VBA, please feel free to let me know.


This will help you see and start to learn how macros are built:

Go to Tools | Macro | Record New Macro

Then work through what you would have the macro do by hand.

Don't try to do the whole thing at once, just do a few steps.

Then go to Tools | Macro | Stop Macro (this is probably called
something similar to this, I jdon't have it in front of me)

Then look at the macro that's been recorded.

Then post any questions you have and we can help you from there.

There is also a help file you can download from Microsoft on VBA.

For instance for Office 20000, go to microsoft.com and do a search for
VBA office 2000 help file and you can download it.

There are good books also, but try this stuff first. The help file
will give you an overview of how it works.

Greg