Clearing references?
 

I run a piece of code which performs the following:

Wkbk1 contains a macro which opens wkbk2.
A macro located in wkbk2 is run from wkbk1.
wkbk2 macro runs a stored proc which returns data to wkbk2.sheet1
a querytable located in wkbk2.sheet2 is based on the data in
wkbk2.sheet1.

The following line of code (in wkbk2):
RANGE(\"QT_MFTP\").QUERYTABLE.REFRESH BACKGROUNDQUERY:=TRUE
creates an internal reference to wkbk2.

When I use - Workbooks(wkbk2).Close True
The vbaproject reference still remains in my editor and doesnt go until
I close and repoen the whole excel application.

Help appreciated.
Cheers,
Matt


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=384327