|Subject:||Win32::OLE::Const causes a problem with getOpenFile/getSaveFile|
Hi, I have several applications which use Perl/Tk for the gui and Win32::OLE to read from and write to Excel. I have discovered that: use Win32::OLE::Const 'Microsoft Excel'; introduces a problem with getOpenFile and getSaveFile, namely clicking the 'My Documents' button in the file select window locks up the application. Trying to close the window gives a 'This program is not responding' window, and the only way out is to click 'End Now'. It doesn't matter how long you wait, the program bever recovers. The same thing happens if you select 'My Documents' from the pull down list or click 'Desktop' then 'My Documents' from there. Basically you cannot go directly to 'My Documents', but you can navigate there the slow way. I have done a little experimenting and tried using the actual numbers in my code instead of calling Win32::OLE::Const. This is fine until after the first time the program actually opens Excel, then after that we are back to the fault situation. This fault existed in previous versions of Perl 5.6 also. I am using Windows 2000 operating system. My perl distribution is: C:\Documents and Settings\epajsb>perl -v This is perl, v5.8.8 built for MSWin32-x86-multi-thread (with 25 registered patches, see perl -V for more detail) Copyright 1987-2006, Larry Wall Binary build 817  provided by ActiveStateBuilt Mar 20 2006 17:54:25 According to my Perl documentation the version of Win32::OLE is Version 0.1704 28 November 2005 Thanks in advance for your time.