Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

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

by HelenCr (Monk)
on Aug 06, 2012 at 13:13 UTC ( #985700=note: print w/ replies, xml ) Need Help??


in reply to Re: "use Win32::OLE::Const" not having an effect
in thread "use Win32::OLE::Const" not having an effect

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


Comment on Re^2: "use Win32::OLE::Const" not having an effect
Select or Download Code
Re^3: "use Win32::OLE::Const" not having an effect
by dasgar (Deacon) 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.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://985700]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (13)
As of 2014-07-23 09:59 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite superfluous repetitious redundant duplicative phrase is:









    Results (139 votes), past polls