Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Exit IE editor and open Word

Status
Not open for further replies.

mnolting

Programmer
Oct 6, 2008
26
US
I have the following task for a VBA program to run after opening a word doc attachment in a Microsoft Exchange internet server. eg
1. Obtain information within the doc to determine WHERE to store it locally and the NAME for the file (Which I already wrote and works)
2. EXIT the IE window that has the document open (which is a separate window).
3. Open that document in WORD. NOT THE IE EDITOR. If Word is not open, then start it up with that document open.

Here is some caveats:
1. "shell"ing to "Winword.exe" will open a new , separate instanced of Word if it is already open, don't want that, I encounter weird errors attempting to close that instance.
2. The obvious "Quit" app is quote "Not available"
3. "Sendkeys %FX to the IE window is unreliable and intermittent.
4. "AppActivate "Microsoft Word" is quote "Un available"
Thanks
Mike
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top