Global macro insertion

[CLR]

Hi All......

Is it possible with VBA, to insert a pre-recorded macro into multiple Excel
files (all) in a given directory, automatically? And, given that AutoCAD
understands VBA also, could the same be done to a group of AutoCAD files?

And, if possible, can the inserted macro be of the Auto-run type, so that it
will start and run the next time each file is opened?

TIA
Vaya con DIos,
Chuck, CABGx3

 

[Tom Ogilvy]

Look at Chip Pearson's page on working with code using code:

http://www.cpearson.com/excel/vbe.htm

You can make it a macro named Autpen if you want or create a
workbook_open event.

I can't say anything about VBA in AutoCAD.

 

[CLR]

Thanks Tom, ......
I've printed out all 11 pages of Chip's article, and will try to digest it
today while I'm waiting in line for my Abdominal Aortic
Screening........hopefully I'll be able to understand it.......<g>

Vaya con Dios,
Chuck, CABGx3