possible to execute a .bat using VB script?

[dalex17]

Hello,

Is it possible to execute a batch file using VB Script editor?

If so, I would like to know the code.

Dalex

 

[ETID]

in vba you use the shell command

shell("c:\my_batch.bat&quot

 

[dalex17]

thank you for the reply ETID.

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?

 

[dalex17]

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.

I sure hope I made sense

Dalex