Disconnecting from an External Workbook Data Source
 

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

Disconnecting from an External Workbook Data Source
 

Edit Links Break Link

Regards,
Ryan---
--
RyGuy


"Rob" wrote:

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