Re: HOW to call a Excel Macro subroutine from perl

Replies are listed 'Best First'.
Re^2: HOW to call a Excel Macro subroutine from perl by marlboroguy58 (Novice) on Apr 10, 2007 at 06:36 UTC
hi, tried it...It works...thanx... i feel that i didn't know what was the problem.. thanx again	[reply]
Re^2: HOW to call a Excel Macro subroutine from perl by marlboroguy58 (Novice) on Apr 10, 2007 at 08:53 UTC
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?	[reply] [d/l]
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]