When i open the excel workbook, i get a dialog pop up, asking to update the
links present in the Excel workbook(as used cells refers to the underlying
macros)

I want to disable this dialog programmtically when i we Open the workbook
directly by double click or File|Open.

I know, we can set the option from Edit|Links to disable this pop-up or from
the start-up under options but want to do this programmtically.

Please help.

Thanks,
Sandeep

The Workbook Open method has an optional Update Links argument.
There are four values you can apply. See the Excel VBA help file to find the
appropriate value.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Sandeep"
wrote in message
When i open the excel workbook, i get a dialog pop up, asking to update the
links present in the Excel workbook(as used cells refers to the underlying
macros)
I want to disable this dialog programmtically when i we Open the workbook
directly by double click or File|Open.
I know, we can set the option from Edit|Links to disable this pop-up or from
the start-up under options but want to do this programmtically.
Please help.
Thanks,
Sandeep

Hi,

I am not using the Workbook open method to open.
Rather we simply open the Excel Workbook from the File|Open

Thanks,
Sandeep

"Jim Cone" wrote:


The Workbook Open method has an optional Update Links argument.
There are four values you can apply. See the Excel VBA help file to find the
appropriate value.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Sandeep"
wrote in message
When i open the excel workbook, i get a dialog pop up, asking to update the
links present in the Excel workbook(as used cells refers to the underlying
macros)
I want to disable this dialog programmtically when i we Open the workbook
directly by double click or File|Open.
I know, we can set the option from Edit|Links to disable this pop-up or from
the start-up under options but want to do this programmtically.
Please help.
Thanks,
Sandeep

"but want to do this programmtically"???
-
Maybe: Tools | Options | Calculation (tab) and uncheck "Update remote references".
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"Sandeep"
wrote in message
Hi,
I am not using the Workbook open method to open.
Rather we simply open the Excel Workbook from the File|Open
Thanks,
Sandeep


"Jim Cone" wrote:
The Workbook Open method has an optional Update Links argument.
There are four values you can apply. See the Excel VBA help file to find the
appropriate value.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Sandeep"
wrote in message
When i open the excel workbook, i get a dialog pop up, asking to update the
links present in the Excel workbook(as used cells refers to the underlying
macros)
I want to disable this dialog programmtically when i we Open the workbook
directly by double click or File|Open.
I know, we can set the option from Edit|Links to disable this pop-up or from
the start-up under options but want to do this programmtically.
Please help.
Thanks,
Sandeep