Telling excel to update or not to update
 

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

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?

Telling excel to update or not to update
 

Where would this go in the code below?

Workbooks.Open filename:= _
"C:\Documents and Settings\cnether\My Documents\Development\Supplier
KPI Reports\Supplier KPI Collation.xls", ReadOnly:=False, Password:="",
WriteResPassword:="secure"

"Utkarsh" wrote:

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?