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

Ignoring a runtime error 1
populate a combobox based on unique values in another workbook 16
Delete all, but the last 23 lines of an external text file 12
Hotkey in proper workbook 2
merge data macro 4
Adding custom menus to existing excel application 0
Pull data (sumif?) from an external workbook 2
VBA code to import worksheets from other workbooks 9

Top