Workbook.Open

HunterN · May 8th, 2002, 11:16 AM

Hi!

I have in a macro the command
Workbook.Open filename:="...."

Can anyone tell me if there is a way to make it so it won't ask me to update the workbook when it opens? I want it to automatically select the option - No.

Thanks

EdE · May 8th, 2002, 12:22 PM

Hi Hunter --

Workbook.open filename:="....", updatelinks:=0

0=no updates
1=update external but not remote references
2=update remote but not external references
3=updates both

Hope this helps!

HunterN · May 8th, 2002, 12:31 PM

Thanks!

That is what I needed.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 8th, 2002, 11:16 AM	#1
HunterN Board Regular Join Date: Mar 2002 Location: Maryland Posts: 424	Hi! I have in a macro the command Workbook.Open filename:="...." Can anyone tell me if there is a way to make it so it won't ask me to update the workbook when it opens? I want it to automatically select the option - No. Thanks

May 8th, 2002, 12:22 PM	#2
EdE Board Regular Join Date: Apr 2002 Location: A Mile High!! Posts: 230	Hi Hunter -- Workbook.open filename:="....", updatelinks:=0 0=no updates 1=update external but not remote references 2=update remote but not external references 3=updates both Hope this helps!

May 8th, 2002, 12:31 PM	#3
HunterN Board Regular Join Date: Mar 2002 Location: Maryland Posts: 424	Thanks! That is what I needed.