Hi

I have approx 200 simple templates all of which are the same in layout, i'm
using a simple macro which uses a loop to open each file pick up bits of info
and lay it out on a list.

The problem i have is some of these files have external links and when the
macro opens them i get the message "Do i want to update links" which also
pauses the macro until i click update or dont update. Is it possible to put
a code within the macro which automatically selects dont update if a file has
links. I've displayalerts = false but this doesnt seem to work

thanks in advance

Hervinder

See: http://www.ozgrid.com/VBA/update-links.htm



--
Regards
Dave Hawley
www.ozgrid.com
"hervinder" <(E-Mail Removed)> wrote in message
news:C13FA1B1-6EEE-49BC-8B9A-(E-Mail Removed)...
> Hi
>
> I have approx 200 simple templates all of which are the same in layout,
> i'm
> using a simple macro which uses a loop to open each file pick up bits of
> info
> and lay it out on a list.
>
> The problem i have is some of these files have external links and when the
> macro opens them i get the message "Do i want to update links" which also
> pauses the macro until i click update or dont update. Is it possible to
> put
> a code within the macro which automatically selects dont update if a file
> has
> links. I've displayalerts = false but this doesnt seem to work
>
> thanks in advance
>
> Hervinder
>
>

such a simple answer, i'm ebarassed i didnt see it

thank you

"ozgrid.com" wrote:

> See: http://www.ozgrid.com/VBA/update-links.htm
>
>
>
> --
> Regards
> Dave Hawley
> www.ozgrid.com
> "hervinder" <(E-Mail Removed)> wrote in message
> news:C13FA1B1-6EEE-49BC-8B9A-(E-Mail Removed)...
> > Hi
> >
> > I have approx 200 simple templates all of which are the same in layout,
> > i'm
> > using a simple macro which uses a loop to open each file pick up bits of
> > info
> > and lay it out on a list.
> >
> > The problem i have is some of these files have external links and when the
> > macro opens them i get the message "Do i want to update links" which also
> > pauses the macro until i click update or dont update. Is it possible to
> > put
> > a code within the macro which automatically selects dont update if a file
> > has
> > links. I've displayalerts = false but this doesnt seem to work
> >
> > thanks in advance
> >
> > Hervinder
> >
> >
>
> .
>