Skip to Content
Former Member
May 25, 2010 at 07:17 PM

Calling Excel macro from Vbscript and come back to it


Hi Experts - I was wondering if anybody knows whether this can be done or not:

Start a VbScript in SAP, get a few files created and saved (this part is not problem), then the script opens up Excel and triggers an Excel macro which processes these files, and when done, it hands the control back to Vbscript that called it, and script continues to process from there. There were a few postings on how to open Excel and write data but I am not sure if I can call a macro this way.