Global macro insertion
 

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

Global macro insertion
 

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 Auto_Open if you want or create a
workbook_open event.

I can't say anything about VBA in AutoCAD.

--
Regards,
Tom Ogilvy

CLR wrote in message
...
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

Global macro insertion
 

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



"Tom Ogilvy" wrote in message
...
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 Auto_Open if you want or create a
workbook_open event.

I can't say anything about VBA in AutoCAD.

--
Regards,
Tom Ogilvy

CLR wrote in message
...
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