Hello,

I created a macro that opens up a .doc file after the user is asked to
with Application.GetOpenFilename, and perform some actions. However,
the macro seems to be using the wrong .doc file...a file that I used
hours ago--NOT the one that I'm prompting excel to do.
I just restarted my computer and now its using the correct file. Is
there a script I can add to eliminate this?


--
pikapika13
------------------------------------------------------------------------
pikapika13's Profile: http://www.excelforum.com/member.php...o&userid=10892
View this thread: http://www.excelforum.com/showthread...hreadid=546816

Possibly you have never successfully closed that instance of work due to a
persistent reference. Before you run the code a second time, go into the
task manager and see if Word.exe is already running.

--
Regards,
Tom Ogilvy



"pikapika13" wrote:


Hello,

I created a macro that opens up a .doc file after the user is asked to
with Application.GetOpenFilename, and perform some actions. However,
the macro seems to be using the wrong .doc file...a file that I used
hours ago--NOT the one that I'm prompting excel to do.
I just restarted my computer and now its using the correct file. Is
there a script I can add to eliminate this?


--
pikapika13
------------------------------------------------------------------------
pikapika13's Profile: http://www.excelforum.com/member.php...o&userid=10892
View this thread: http://www.excelforum.com/showthread...hreadid=546816