Ghost Reference

[pikapika13]

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?

[Tom Ogilvy]

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