Clearing references?

M

MattShoreson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top