Re^2: HOW to call a Excel Macro subroutine from perl

with regards to excel i m having another problem the same script after populating the data and saving, and closing the workbook, will populate another workbook. When it tries to do that i get the following error

Win32::OLE(0.1701) error 0x8001010a: "The message filter indicated tha
+t the
application is busy"
    in METHOD/PROPERTYGET "" at populator.pl line 17
[download]

the script will create an excel object for every file it will open..is this wrong? do i need to destroy the object?

Comment on Re^2: HOW to call a Excel Macro subroutine from perl Download Code

Replies are listed 'Best First'.
Re^3: HOW to call a Excel Macro subroutine from perl by roboticus (Chancellor) on Apr 10, 2007 at 11:21 UTC
marlboroguy58: It's rather difficult to find the error without seeing the code. My best (blind) guess would be that you should simply skip the creation of the excel object after the first invocation. Something like: `$XL = ExcelObject(...) unless $XL;` [download] ...roboticus	[reply] [d/l]
Re^4: HOW to call a Excel Macro subroutine from perl by marlboroguy58 (Novice) on Apr 16, 2007 at 04:36 UTC
works! thanx a lot enlightened one.	[reply]