Update macro script

N

Naveen

Hi,
I have created one excel macro. Is it possible for me to update the
macro script using some external application without opening the excel
file. I am looking some something like an exe application which will
just update the script and not the data in the sheet.

Thanks in advance
 
A

Alex Turner

Hi,
I have created one excel macro. Is it possible for me to update the
macro script using some external application without opening the excel
file. I am looking some something like an exe application which will
just update the script and not the data in the sheet.

Thanks in advance
Click to expand...


Pretty much no :)

If you are wanting to do this, why not put the macro outside of Excel in
the first place, use a scripting macro
http://nerds-central.blogspot.com/2008/01/excel-vbscript-index-page.html
 
Top