VBA to control Internet Explorer to open files

[rugbykorn]

Hello,

I am trying to use VBA to control Internet Explorer as I'm hoping to open som XPS files and utilize some of the data in one of the files. When Attempting to run some simple code from the above sample I appear to be missing a reference. Do you know what reference library I need to turn on to run code relating to IE?

Thanks,

RugbyKorn

[JosephP]

microsoft internet controls

[rugbykorn]

@JosephP

Thanks for the reply, that is what I was looking for, found it slightly before you got back to me. Oddly I didn't get an email saying you replied so I'll make sure to check back in a bit.

My next step, now that I am controlling IE is to open an XPS document (which I can do), then to search the XPS document. I am trying to use the inStr function to search it but unfortunately I can't seem to figure out what the document itself should be referred to.

So:

Please Login or Register  to view this content.

"Active Document" could be replaced with innerHTML but its not a website so I don't think there is HTML. I tried using innerText but that doesn't seem to work (it doesn't validate that the word "test" is present in the document, which it is).

My full code is:

Please Login or Register  to view this content.

I would expect the msg box at the end to contain the position of the "ToFind" string but it keeps coming back 0. I tried outerText and no luck there either.

Would greatly appreciate any suggestions you may have.

RugbyKorn