Re: "use Win32::OLE::Const" not having an effect

First, are you sure that you listed the correct versions of Strawberry Perl? Based on the available downloads from Strawberry Perl's web site, I think you mean version 5.14.2.1 instead of version 5.014 and version 5.16.0.1 instead of version 5.016.

Do both systems have Excel installed? If the new system does not have Excel installed, then your code will not be able to load the Microsoft Excel Object Library since it won't exist on that system.

Comment on Re: "use Win32::OLE::Const" not having an effect

Replies are listed 'Best First'.
Re^2: "use Win32::OLE::Const" not having an effect by HelenCr (Monk) on Aug 06, 2012 at 13:13 UTC
dasgar: thank you for your good reply. I have just answered you, but strangely, it seems the answer has disappeared and doesn't show up in the thread, so I'm trying again. a. I think you are right about the Strawberry Perl versions. My original Windows 7 system has 5.14.2.1 installed; but I think you have to say: `use 5.014;` The new Win XP system I'm trying to make work has 5.16.0.1 installed, but one has to say: `use 5.016;` Isn't that the case? b. The original Windows 7 system has Excel 2010 installed. The Win XP system has Excel 2003 installed. Both Excel installations are working fine. Many TIA - Helen	[reply] [d/l] [select]
Re^3: "use Win32::OLE::Const" not having an effect by dasgar (Priest) on Aug 06, 2012 at 16:05 UTC
My original Windows 7 system has 5.14.2.1 installed; but I think you have to say: use 5.014; The new Win XP system I'm trying to make work has 5.16.0.1 installed, but one has to say: use 5.016; Isn't that the case? Since I have not specified Perl versions like this in my scripts, I'll have to leave that for others who are more knowledgeable to answer that one. I suspect that you would have the same use statement on both systems. The original Windows 7 system has Excel 2010 installed. The Win XP system has Excel 2003 installed. Both Excel installations are working fine. For the most part, your code should work fine with both versions of Excel. The most notable difference that you need to be aware of is the saving of the Excel file.	[reply]