VBA Link & Password Help Please!!

[stephen.smith]

Hey Guys I am trying to update links from other workbooks by using VBA rather than updating through the standard Edit Links-> Update all values. Does anyone know how to do this with VBA. I know this is probably very basic but I cant seem to get it to work. I should also mention that some of the workbooks that I am trying to update with this VBA are password protected. Can I put the password in the code so that it doesnt prompt me to enter the password.
<!-- / message -->
Thanks Again for anyone that has a look and helps me out.
Stephen
<!-- / message -->

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/showthread.php?t=579363

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).