I have two worksheets on different servers and because they have links
you are asked to update the links before you continue.

Is there a way to use VBA to automatically update this link without
the message window opening up?

I need to remove the message window because it confuses my users!

Any and all help is appreciated!

Regards

Karti

On Feb 20, 9:42 am, "Karti" <j...@jetj.net> wrote:
> I have two worksheets on different servers and because they have links
> you are asked to update the links before you continue.
>
> Is there a way to use VBA to automatically update this link without
> the message window opening up?
>
> I need to remove the message window because it confuses my users!
>
> Any and all help is appreciated!
>
> Regards
>
> Karti
>

create an OpenWorkbook() macro that sets UpdateLinks:=1 when the
workbooks open...

-thatdude

Many thanks for the reply.

I now have within VBA

Sub OpenWorkbook()

Application.DisplayAlerts = False
UpdateLinks = 1

End Sub

I still receive the alerts.....any ideas?

Cheers

Karti





On 20 Feb, 16:34, kevinrj0...@gmail.com wrote:
> On Feb 20, 9:42 am, "Karti" <j...@jetj.net> wrote:
>
> > I have two worksheets on different servers and because they have links
> > you are asked to update the links before you continue.
>
> > Is there a way to use VBA to automatically update this link without
> > the message window opening up?
>
> > I need to remove the message window because it confuses my users!
>
> > Any and all help is appreciated!
>
> > Regards
>
> > Karti
> >
>
> create an OpenWorkbook() macro that sets UpdateLinks:=1 when the
> workbooks open...
>
> -thatdude

Actually after playing around I have the following - .

I now have within VBA

Sub OpenWorkbook()

Workbooks.Open Filename:="E:\Excel Test\testOne.xls", UpdateLinks:=3
Application.DisplayAlerts = False


End Sub

Now this works fine when I do it from an open book. But I would like
it to happen when the actual file opens .....any ideas?

Cheers

Karti

Karti,

I would alter that slightly. You are turning DisplayAlerts off and never
turning them back on. This can cause undesired effects. You should never end
your code and leave display alerts off. If the user makes a change and
decides to close the workbook, it will close immediately without asking if
they want to save changes. I also altered the first line also. This allows
the code to run when the workbook opens. The way you had it, it was a simple
macro that could only be run while the workbook was open.

Sub Workbook_Open()
Application.DisplayAlerts = False
Workbooks.Open Filename:="E:\Excel Test\testOne.xls", UpdateLinks:=3
Application.DisplayAlerts = True
End Sub

Regards,

Alan


"Karti" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> Actually after playing around I have the following - .
>
> I now have within VBA
>
> Sub OpenWorkbook()
>
> Workbooks.Open Filename:="E:\Excel Test\testOne.xls", UpdateLinks:=3
> Application.DisplayAlerts = False
>
>
> End Sub
>
> Now this works fine when I do it from an open book. But I would like
> it to happen when the actual file opens .....any ideas?
>
> Cheers
>
> Karti
>
>
>