Clear questions and runnable code get the best and fastest answer |
|
PerlMonks |
Hang during RefreshAll using Win32::OLE and Excelby jrsimmon (Hermit) |
on Mar 05, 2010 at 20:52 UTC ( [id://827064]=perlquestion: print w/replies, xml ) | Need Help?? |
jrsimmon has asked for the wisdom of the Perl Monks concerning the following question:
Noble monks-
I have a script that runs about 10 times per day. It uses Win32::OLE to open excel spreadsheets and refresh them (via MS Query and DB2) and then do stuff with the refreshed data. Every now and then, the script will hang. I think the hang is in either MS Query or Excel, but I thought I'd put the code up and see if anyone can point out an obvious problem I've missed. I've tried to reduce the script down to just the relevant parts without cutting too much...I can expand a bit if needed. When the hang occurs, the last thing I see in the logs is the line "refreshing all..." from just after the eval. Any suggestions are welcome...
Back to
Seekers of Perl Wisdom
|
|