in reply to Re^2: WIN32::OLE Excel Save As
in thread WIN32::OLE Excel Save As

When I change the file format to Save As a .csv file, it runs in seconds.

Well, that sounds pretty conclusive to me. Figuring out why Excel takes so long for the file you're giving it may be a pain, and I doubt that examining your own code further will help a whole lot. Time to ask someone who knows Excel somewhat better.

Replies are listed 'Best First'.
Re^4: WIN32::OLE Excel Save As
by smitty1624 (Initiate) on May 02, 2007 at 22:11 UTC
    Can you help out with where the best place to ask someone who is familiar with Excel?

    I have the script set up to have the user go through the Save As prompt in Excel, which is surprisingly faster then having the script do the Save As.
[reply]

In Section Seekers of Perl Wisdom