View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Malic Malic is offline
external usenet poster
 
Posts: 1
Default Open all linked files and close them.

Hello.

I need to know how to do the following.

Open each linked file in a workbook,
Update Linked Data,
Save Changes,
Close all linked documents.

Thanks. This is to work around the cant update data is more then 2 linked
sheets away.