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