VBA Automation tools

Hi,

Check out your macro recorder. It's about as "automated" as it gets.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

I was going to say the same as skip.

I'll add that I know nothing about the Automate Excel add-in, but I suspect that in the long term you would be better off learning the basics of coding, combined with the macro-recorder, and the vast resources available on the Internet.

Doug Jenkins
Interactive Design Services

Ditto!

There is coding help here and at Eng-Tips sister site, for
MS Office Apps at and
VBA at
Skip,

_{Just traded in my OLD subtlety...
for a NUance!}