Disconnecting from an External Workbook Data Source

  • Thread starter Thread starter Rob
  • Start date Start date
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
 
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.
 
Back
Top