RE: problem during accessing excel using OLE.

2004-11-04 Thread Brian Raven
Chandrasekaran Suresh wrote: > Hi All, > > Someone can tell me how to read a excel file when perl > is running on Unix. The Spreadsheet::* modules can do that (with some limitations). See: http://search.cpan.org/search?query=spreadsheet&mode=all 'ppm search spreadsheet' - yes ma

RE: problem during accessing excel using OLE.

2004-11-03 Thread Chandrasekaran Suresh
Tarun > > -Original Message- > From: Brian Raven [mailto:[EMAIL PROTECTED] > Sent: 03 November 2004 12:21 > To: Tarun,S,Sharma,XGE4C C; > [EMAIL PROTECTED]; > [EMAIL PROTECTED] > Subject: RE: problem during accessing excel using > OLE. > > [EMAIL PROTECTED] w

RE: problem during accessing excel using OLE.

2004-11-03 Thread sharma.tarun
plication. Now all my bugs are fixed. Thanks for your advice and support. Tarun -Original Message- From: Brian Raven [mailto:[EMAIL PROTECTED] Sent: 03 November 2004 12:21 To: Tarun,S,Sharma,XGE4C C; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: problem during accessing excel using O

RE: problem during accessing excel using OLE.

2004-11-03 Thread Brian Raven
[EMAIL PROTECTED] wrote: > Brian, > > When I call close on workbook rather than excel it prompts the message > to save the file. Which need human intervention. That I don't want as > I'm trying to automate the process. Can you tell me any property of > workbook or some way to just close the file w

RE: problem during accessing excel using OLE.

2004-11-03 Thread sharma.tarun
ED]; [EMAIL PROTECTED] Subject: RE: problem during accessing excel using OLE. [EMAIL PROTECTED] wrote: > > You're right Donald. > I open a file, run macro, save it as csv, quit excel, and then open > it again to process the new file. > So, how can I handle this situation. I

RE: problem during accessing excel using OLE.

2004-11-03 Thread Brian Raven
[EMAIL PROTECTED] wrote: > > You're right Donald. > I open a file, run macro, save it as csv, quit excel, and then open > it again to process the new file. > So, how can I handle this situation. I would have thought it better to call close on the workbook object rather than quit on the applicati

RE: problem during accessing excel using OLE.

2004-11-03 Thread sharma.tarun
To: Tarun,S,Sharma,XGE4C C; [EMAIL PROTECTED] Subject: RE: problem during accessing excel using OLE.   I'm assuming your code below is in some sort of look. After you quit Excel, are you re-creating Excel the next time you are ready to open a file? Because if you quit Excel and clean

RE: problem during accessing excel using OLE.

2004-11-02 Thread Stephens, Donald
I'm assuming your code below is in some sort of look. After you quit Excel, are you re-creating Excel the next time you are ready to open a file? Because if you quit Excel and clean it up, then on the next iteration of the loop you won't be able to get any property or methods of $Excel, w