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
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