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



.