how to disable update links message when opening files
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 |
how to disable update links message when opening files
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 |
how to disable update links message when opening files
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 . |
All times are GMT +1. The time now is 07:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com