Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?

Re: Error in Win32::OLE

by Corion (Patriarch)
on Oct 21, 2021 at 09:55 UTC ( #11137843=note: print w/replies, xml ) Need Help??

in reply to Error in Win32::OLE

No type library matching "Microsoft Excel" found at .\/MatrixGenerator line 26.

Maybe Microsoft Excel is not installed on the machine running your program?

The rest is just fallout from that, since all the Excel constants are unknown now.

Replies are listed 'Best First'.
Re^2: Error in Win32::OLE
by ece05 (Initiate) on Oct 21, 2021 at 10:01 UTC

    MS Excel is installed in the PC. I was using the older version at that time

    Now, I am using Microsoft 365. Is this impacting the perl script?

      Maybe Office 365 does not have OLE automation anymore - this seems plausible if Office 365 only runs within the browser, for example.

      Maybe look on your PC whether the type library file is findable and give that to Win32::OLE::Const explicitly.

      The alternative approach if all this fails is to replace all the named constants with their values, which you can acquire from Googling them.

      The latest application versions of Office 365 include OLE blocking. I have no idea if it is turned on by default - I can check sometime as it would be interesting to find out and potentially helpful to you. Here is some information from Microsoft.

      I am pretty certain that the cloud versions of Office 365 do not support OLE. Instead they use the Fluid Framework.

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://11137843]
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: (2)
As of 2022-01-24 04:56 GMT
Find Nodes?
    Voting Booth?
    In 2022, my preferred method to securely store passwords is:

    Results (64 votes). Check out past polls.