PDA

View Full Version : [SOLVED] Set Reference to Explorer



eed
08-09-2004, 08:01 AM
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
08-09-2004, 08:31 AM
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
08-09-2004, 08:41 AM
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!! :hi: