How to I pass a parameter to an Excel macro?
The code I have is:
cFileName = GETFILE("txt")
oExcel = CREATEOBJECT("Excel.Application")
oExcel.Workbooks.Open("MyWorkbook.Xls")
oExcel.Application.Run("MyWorkbook!MyMacro(" + cFileName + ")")
The last line is failing.
Can anyone tell me the correct syntax?
TIA
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
