Set Reference to Explorer

[eed]

Hi, everyone,

I have an html document which I want to manipulate from my database's VBA. I've written a procedure which forces the doc to open in IE (because it cannot be correctly copied-n-pasted from Netscape, for whatever reason). After I have performed my OpenHLink(strPath) procedure to open the doc in IE, I want to perform Select All and Copy commands.

If I were doing this with a Word doc, I'd set a reference to a Word application and document and use those objects to select and copy data. I guess what I'm struggling with is, How do I set a reference to Explorer so that I can tell my code where to set the focus and select and copy?

All help is greatly appreciated, as ever. Thanks for your time/thought power!

[Pat Hartman]

This is not my area of expertise so sorry if any of this sounds dumb

Why not open the HTML in Word?

If you need to use IE, can you use SendKeys to send keystrokes to manipulate the interface?

[eed]

This is not my area of expertise so sorry if any of this sounds dumb

Why not open the HTML in Word?

If you need to use IE, can you use SendKeys to send keystrokes to manipulate the interface?

Okay, I feel silly. Opening the HTML in Word worked fine, and it copied and pasted into my other Word document perfectly.

Now why didn't I think of that...? Thanks a bunch!!