Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Problem with VBScript calling VBA macro: macro is called twice...
In the meantime I solved the problem. I'm posting the answer, somebody might be interested... (1) The Excel macro must be called like this: XLHandle.Run "MyMacro", 15 (where 15 is an example argument) instead of XLHandle.Run("MyMacro(15)" While the latter also works, this is responsible for... -
Problem with VBScript calling VBA macro: macro is called twice...
Dear tek-tips people, maybe you can help me with the following VBScript problem: I am calling an Excel VBA macro from a VBScript, the problem is: The macro is run twice - though I only call it once...! Here are the details: I am running a batch file which calls a VBScript together with a...
