What I failed to state in my earlier message was that I am trying to enter this code in Cognos Script Editor. Being the novice that I am, I thought they might function the same; which I do not think they do...
Do you have any additional thoughts based on this new piece of information?
I created a macro, using Cognos Script Editor, which automatically creates (save as) an .xls file from an Impromptu report (Impromptu is a report writer software).
I then created a simple batch file which opens the .xls file. So far so good.
The challenge I am having is that every time I run the macro which creates the .xls file, it overwrites any macros I wrote in vba in excel..so when the .xls is opened nothing happens.
My vbs script in excel is suppose to perform some custom actions each time it is opened, however each time the macro overwrites the excel file the script dissapears. It would be great if the macro can overwrite the data of the existing excel file, but not any of the vba code.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.