Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much

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


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.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1027238]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (4)
As of 2018-06-19 00:12 GMT
Find Nodes?
    Voting Booth?
    Should cpanminus be part of the standard Perl release?

    Results (111 votes). Check out past polls.