Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

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

by dasgar (Deacon)
on Aug 06, 2012 at 05:06 UTC ( #985599=note: print w/ replies, xml ) Need Help??


in reply to "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
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

      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://985599]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (6)
As of 2014-08-31 09:25 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (294 votes), past polls