Macro to loop in subfolders, change links, export xml data

Catalin.B · #3 09-08-2011, 11:37 PM

Quote:

Originally Posted by Catalin.B

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..

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Made a mistake with a macro change	lance_kidd	Word	0	02-09-2011 06:36 PM
Accessing Outlook Contacts in Subfolders	jill5545	Outlook	1	11-17-2010 04:01 PM
Create a Custome Form and export data to Access	ashleybyrdnc	Office	0	03-05-2010 09:41 AM
Macro to export document sections to individual txt files?	MJMR999	Excel Programming	0	02-18-2010 12:49 PM
Subfolders in Inbox and Sent Items	stevie	Outlook	0	09-08-2009 02:02 AM