Thread: [Solved] Macro to loop in subfolders, change links, export xml data
View Single Post
 
Old 09-08-2011, 11:37 PM
Catalin.B Catalin.B is offline Windows Vista Office 2007
Expert
  
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default
Quote:
Originally Posted by Catalin.B View Post

The problem is that the workbook with the path in red is password protected, and prompts for password at every change of links...
Unfortunately, i couldn't find a way to paste the password in the prompt for password for changing links.. There is no need to open the workbook, the paste password works only for workbook open or update links.

Is there a way to capture the prompt for password window and to insert password for changing links?
As i noticed that Mr. Paul Edstein is back, maybe i get an answer too from this old thread..
Reply With Quote