in reply to Re: Execute VBScript in perl to work on .xlsm
in thread Execute VBScript in perl to work on .xlsm

I am not sure if that should be a problem. Still, I did try $wrk_book->SaveAs(). Still getting the same error. Appreciate any inputs on making it work the cscript way also, as it seems simple enough. It seems to not being able to locate the input file itself, which seems to indicate some issue with file path notation?? I tried all possible ways, forward slashes,backward slashes, double slashes. Apache seems to append an extra slash in the file path location. Is that a problem? Any way to work around it. Kindly let me know your opinions.

Thanks a lot.

  • Comment on Re^2: Execute VBScript in perl to work on .xlsm

Replies are listed 'Best First'.
Re^3: Execute VBScript in perl to work on .xlsm
by suzun30 (Acolyte) on Apr 15, 2013 at 20:51 UTC
    I understood that the workbook object is not defined since the $wrk_book->Open("file") failed. But the same script when executed independently as a .pl file works fine. I am calling this functionality on my webpage. Apart from this there is no other difference in the code. Appreciate any inputs.