Can you edit hyperlinks across multiple documents?

[Libba-PSU]

A URL link that we've used many times across hundreds of documents recently changed and there is no redirect on their site either. Anyone know of a script or a way to do this across many files?

I'm afraid maybe there was a better way to handle this. Alternatively to an easy find/replace fix, is there any advice for going forward? Is there a smart way to set up common links so that you can more easily change them in the future?

[Jay Maechtlen]

I know that it can be done in Word/Excel VBA, and I'm sure it can be done here.

Unfortunately, I have not yet buckled down to learn Javascript &/or Id's object model.

As a thought, at a previous employer, I wrote a script that would read a doc that contained destination names and the associated updated hyperlink destinations. It opened the doc to update, looked at each hyperlink, found its destination name from the data doc, and plugged in the updated hyperlink destination.

It probably wasn't the most efficient or elegant approach, but it did work.

- can you script the current ID with vba?

Good luck!

[Jay Maechtlen]

Re the thousands of files:

In vba there are lots of samples showing how to select a directory and then get a list of files in that directory, so your program/macro can process each of them. (look in Word/Excel VBA forums for those)

Re the script - I read the data doc once and put the info into a variable array, I think.

The processed the doc, or the directory full of docs as needed.

It probably wasn't the most efficient or elegant approach, but it did work. And it could process a single file or a directory full of them.

- can you script the current ID with vba?

Again, prob available in the JS/Adobe domain, but I haven't attempted yet.

[Libba-PSU]

Thanks for your responses. I've never tinkered with VBA, but it's an interesting idea. I'll have to think about if this helps me or not.