This will work, where Report is an Excel macro (subroutine) and I pass 2 parameters to it:
xlApp.Run "Report", CStr(StartCount), CStr(EndCount)
But if Report is a function, and I want it to return a value to the VBScript, I can't get it to work. Have tried variations of this:
ReturnValue = xlApp.Run "Report", CStr(StartCount), CStr(EndCount)
I get an "expected end of statement" error right before "Report"