louie has asked for the wisdom of the Perl Monks concerning the following question:

I am entering sth to a excel with MS office. At the same time, I launch the perl script which will "Open" a excel file to parse. So I want to save the excel which I am editing with office first. Then the script could "Open" another excel file. So how could I save the editing excel by MS office through the script? Thanks in advance for your help.

Replies are listed 'Best First'.
Re: How to save the editing excel?
by roboticus (Chancellor) on May 13, 2010 at 03:03 UTC

    louie:

    Since you're using MS Office, I'm guessing you're using Win32::OLE to drive Excel. In that event, it's not really a perl question, but an Excel API question. For that, you'll need to refer to Microsoft's documentation. I expect that you'll likely call a method named something like Save to actually save the workbook.

    ...roboticus

[reply]

Back to Seekers of Perl Wisdom