in reply to Execute VBScript in perl to work on .xlsm

One too many variables, one too many arrows

$excel->$wrk_book->SaveAs(...

Replies are listed 'Best First'.
Re^2: Execute VBScript in perl to work on .xlsm
by suzun30 (Acolyte) on Apr 08, 2013 at 17:28 UTC

    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.

      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.