Disconnecting from an External Workbook Data Source

R

Rob

I have a workbook that updates a series of worksheets and tables by importing
it's needed data from other external workbooks. Everything works fine except
that once the data has been updated/imported into the desired workbook the
connected external workbooks are still active and can only be opened in read
only mode. But when I close the workbook that opened the external workbooks
for data collection the other workbooks that were queried from are now
editable.

Does anyone know how I can disconnect or fully close a workbook via a Macro
or VB script in Excel 2003?

Thanks Very Much,
Rob
 
R

Rob

Thanks for the reply ryguy. Unfortunately that is not working. When I go tolinked. The one that does show as being linked I went ahead and selected it
and chose Break Link as instructed but it still would not allow me to do what
I needed to. I still have to close the workbook that is pulling the data
from the external workbooks in order to be able to do anything further. Once
I close it and re-open it then everything works fine.
 

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

Similar Threads

How to reference a cell from anther workbook without opening it 0
merge data macro 4
Close Referenced Workbook if it's No Longer Referenced 4
Remotely close a workbook 1
Macro to copy sheets to another workbook fails after about 45 copi 3
Database Workbook 1
Pull data (sumif?) from an external workbook 1
Copy Autofilter Source Workbook A result in Destination Workbook BSheet1 1

Top