Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation

Re: Win32::OLE(0.1702) error 0x80020011

by Roger (Parson)
on Aug 29, 2005 at 14:03 UTC ( #487419=note: print w/replies, xml ) Need Help??

in reply to Win32::OLE(0.1702) error 0x80020011

I suspect that you had this script working in the past, but after you have upgraded the version of Windows (possibly to XP?) and also the version of office, it stopped working. Is that so?

The old version of office products and the XP versions are different. Old versions have a single main window, and workbooks open in the same window in MDI (multiple document interface) mode.

The new version of office products have multiple windows, one window for each active workbook. They group into a collection of windows for the same application. You will need to first determine the active document (or active workbook), and then operate on the active document.

I haven't run your code, so this is all guess work.

  • Comment on Re: Win32::OLE(0.1702) error 0x80020011

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (3)
As of 2022-09-30 05:46 GMT
Find Nodes?
    Voting Booth?
    I prefer my indexes to start at:

    Results (125 votes). Check out past polls.