Install ThisWorkbook and Module1 files with batch script
 

In Excel VBA, I know I can create Add-ins for userDefined functions. However,
can I install a "ThisWorkbook" file and "Module1" to an existing Excel sheet,
ideally through a batch script. Is this even possible?

Thanks,
Mark

Install ThisWorkbook and Module1 files with batch script
 

Hi Mark,

See Chip Pearson's page on VBE programming at:

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


---
Regards,
Norman



"Mark" wrote in message
...
In Excel VBA, I know I can create Add-ins for userDefined functions.
However,
can I install a "ThisWorkbook" file and "Module1" to an existing Excel
sheet,
ideally through a batch script. Is this even possible?

Thanks,
Mark

Install ThisWorkbook and Module1 files with batch script
 

Look at Chip Pearson's page on this topic

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

--
Regards,
Tom Ogilvy

"Mark" wrote in message
...
In Excel VBA, I know I can create Add-ins for userDefined functions.
However,
can I install a "ThisWorkbook" file and "Module1" to an existing Excel
sheet,
ideally through a batch script. Is this even possible?

Thanks,
Mark

Install ThisWorkbook and Module1 files with batch script
 

Hi Mark,

Chip Pearson describes very well how to do it -

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

Be sure to read his notes about setting a ref' to the VBA Extensibility
library.

Regards,
Peter T

"Mark" wrote in message
...
In Excel VBA, I know I can create Add-ins for userDefined functions.
However,
can I install a "ThisWorkbook" file and "Module1" to an existing Excel
sheet,
ideally through a batch script. Is this even possible?

Thanks,
Mark