EXCEL automation

2002-01-07 Thread Billie
Hi all, What's wrong with the following code? use Win32::OLE; $book = Win32::OLE->GetObject("Book1.xls"); $book->Saveas("Book2.xls"); Book1 and the script are in the same directory. When I open Book2.xls, I cannot see any worksheet. Why? Thanks Billie -- To unsubscribe, e-mail: [EMAIL P

RE: EXCEL automation

2002-01-07 Thread Ryan Guy
Maybe youre just a wuss. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

RE: EXCEL automation

2002-01-07 Thread Stout, Joel R
Not sure, but if you go to Window -> Unhide you can see that the book was created successfully. Maybe a Win32 Perl Guru can help more. Joel > -Original Message- > From: Billie [mailto:[EMAIL PROTECTED]] > Sent: Monday, January 07, 2002 7:15 AM > To: [EMAIL PROTECTED] &

Re: EXCEL automation

2002-01-08 Thread Jenda Krynicky
From: "Billie" <[EMAIL PROTECTED]> > What's wrong with the following code? > > use Win32::OLE; > $book = Win32::OLE->GetObject("Book1.xls"); > $book->Saveas("Book2.xls"); > > Book1 and the script are in the same directory. When I open > Book2.xls, I cannot see any worksheet.