getOpenFile fault when using OLE with Excel.

epajsb has asked for the wisdom of the Perl Monks concerning the following question:

Hi all, I am using Windows 2000 & Perl 5.6.1 (the later version isn't compatible with my 'perl2exe').

I have written a program which outputs a report in Excel.

In order to format the Excel nicely, I include the line:
use Win32::OLE::Const 'Microsoft Excel';

This interferes with the operation of getOpenFile (and getSaveFile). If you press the 'My Documents' button in the getOpenFile window, it freezes and you have to kill the program. Likewise if you select 'Desktop' and double click on 'My Documents'.

Removing the use line above fixes the problem (but stops you from formatting your Excel nicely).

Has anyone else come across this and do you have a solution ??

Thanks in advance.

Comment on getOpenFile fault when using OLE with Excel.