Vba updating links
This is the closest I have got to getting it to work but I can't get past this password issue when running the macro.
Hi, it is a very basic Macro which goes to the other protected file, I recorded it as I went to the file, added the password and refreshed the links. However, it still comes up and asks for the password to refresh the data every time.
Screen Updating = False 'hides most of the activity of opening/closing a file. Open(Filename:="R:\Manufacturing and Operations\Stock & Priorities\Lecia - Artwork Allocated\Artwork Allocated.xls", Password:="a") 'adjust the password!
You can also update only some of the links, if the workbook contains more than one link.
All of the code is still contained in the sht TOC sheet module, and the sheet can be copied to other workbooks.
A Table of Contents is a simple yet extremely useful feature in any Excel workbook that contains more than a few sheets.
It is possible to accidentally create a link by moving or copying a range, worksheet, or chart between workbooks.
Open the workbook, and then find the links that were created, and either break the link or replace it with a value. Because this action cannot be undone, you may want to save a version of the file.