On Jun 22, 9:06*pm, "Ron de Bruin" wrote:
Hi Len

Tip 1: Useful Workbooks.Open arguments

Set mybook = Workbooks.Open(MyPath & MyFiles(Fnum), _
Password:="ron", WriteResPassword:="ron", UpdateLinks:=0)

If your workbooks are protected you can us this in the Workbooks.Open arguments
Password:="ron" and WriteResPassword:="ron"

If you have links in your workbook this (UpdateLinks:=0) will avoid the message
do you want to update the links or not "0 Doesn't update any references"
Use 3 instead of 0 if you want to update the links.

See the VBA help for more information about the Workbooks.Open arguments

This is *apart of this pagehttp://www.rondebruin.nl/copy3.htm

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm



"Len" wrote in ...
Hi,

How to set an excel VBA code to disable or ignore the message box
prompts as " This workbook contains links to other data sources.If you
update the link...... If you don't update the link.... " in the mid of
executing a macro.

Please help, thanks

Regards
Len- Hide quoted text -

- Show quoted text -

Hi Ron,

Thanks for your tips and and it works


Cheers
Len