Set Reference to Explorer
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!
SOLVED - set reference to Explorer
Quote:
Originally Posted by 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?
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:
