Disable a message box

[Len]

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

 

[Per Jessen]

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

Hi Len

Application.DisplayAlerts = False


Remember to set it = True when you are done.

Regards,
Per

 

[Ron de Bruin]

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 page
http://www.rondebruin.nl/copy3.htm

 

[Len]

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 themessage
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








- Show quoted text -

Hi Ron,

Thanks for your tips and and it works


Cheers
Len

 

[Len]

Hi Len

Application.DisplayAlerts = False

Remember to set it = True when you are done.

Regards,
Per

Hi Per,

Thanks for your reply and based on your suggestion, I try to set a
macro as follows and run it : -


Application.DisplayAlerts = False
Workbooks.Open _
Filename:="F:\Accts\Jap\May'08\OA.May'08.4th.xls",
Application.DisplayAlerts = True

However, it still prompts the same message box in the mid of running
the macro.

Did I miss out anything in the above code ?

Regards
Len