Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Row Insertion | Excel Discussion (Misc queries) | |||
Global Macro | Excel Discussion (Misc queries) | |||
Global Macro Adding rows or colums to many Excel files at the same | Excel Discussion (Misc queries) | |||
Changing Cell Reference in a macro on global base | Excel Discussion (Misc queries) | |||
Global Macro | New Users to Excel |