Vba updating links practice dating games
I am completely new to Marcos but due to some great advice in another post on the forum I am trying to get a macro to update links I have in a workbook that is linked to another excel file sat on a network drive but it has a password protection!I have recorded the marco opening the 'edit links' and then clicking update values, I add the password for the excel file the links are reading from and stop 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.
The TOC will display an accurate list when you add, remove, or change the names of sheets in the workbook.
In this example I use two macros to update the Table of Contents. This macro will run every time the user selects the Table of Contents sheet.
Here's a link to the file I use in the video that includes the VBA macros.
Table Of Contents Auto Update (39.1 KB)The following file will work with workbooks that contain Chart sheets. Chart sheets are a special type of sheet that only contains a single chart that takes up the entire sheet.
After opening the workbook, on the Data tab, in the Connections group, click Edit Links, and then update the links only from the sources that you need.