View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Utkarsh Utkarsh is offline
external usenet poster
 
Posts: 18
Default Telling excel to update or not to update

Not to update
Workbooks.Open ("Test.xls"), False

To update
Workbooks.Open ("Test.xls"), True

Utkarsh

Chris wrote:

What code is needed to tell excel to update a file when opened and not to
update a file when opened?