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 <ltong2000...@yahoo.co.uk> 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 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" <(E-Mail Removed)> wrote in message news:9384f8ef-043b-47f7-b6f8-(E-Mail Removed)...
> 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" <rondebr...@kabelfoon.nl> 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 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
>
>
>
> "Len" <ltong2000...@yahoo.co.uk> wrote in messagenews:9384f8ef-043b-47f7-b6f8-(E-Mail Removed)...
> > 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

On Jun 22, 4:25*pm, Per Jessen <perjesse...@hotmail.com> wrote:
> On 22 Jun., 08:59, Len <ltong2000...@yahoo.co.uk> 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