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

On 22 Jun., 08:59, Len wrote:
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

On Jun 22, 4:25*pm, Per Jessen wrote:
On 22 Jun., 08:59, Len wrote:

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

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

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Len" wrote in message ...
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

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