Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Re: Execute VBScript in perl to work on .xlsm

by Anonymous Monk
on Apr 06, 2013 at 02:02 UTC ( #1027238=note: print w/ replies, xml ) Need Help??


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

One too many variables, one too many arrows

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


Comment on Re: Execute VBScript in perl to work on .xlsm
Download Code
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.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1027238]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (7)
As of 2014-08-27 23:56 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (253 votes), past polls