Find hyperlinks in office files

J

jans__

We have installed a new server. Now we have the following problem.
We have hundreds of files with hyperlinks in them. Word, Access, Excel

Is there a way to find and replace all the hyperlinks?

I have a directory with hundreds of subdirectories

Is there a way to loop through als these directories en to find all
files with have hyperlinks in them?

I know how to write vba to change hyperlinks, but at this point if i
would have to write code, i would have to open all files and search for
hyperlinks, perhaps anyone knows a faster way to check if a file has a
hyperlink in it.

Thanx
 
J

Jonathan West

We have installed a new server. Now we have the following problem.
We have hundreds of files with hyperlinks in them. Word, Access, Excel

Is there a way to find and replace all the hyperlinks?

I have a directory with hundreds of subdirectories

Is there a way to loop through als these directories en to find all
files with have hyperlinks in them?
Click to expand...

In Word, use the Application.FileSearch object, and set the SearchSubfolders
property to True. Then when you use the Execute method to run the search, it
will find matching files in subfolders of the specified folder.

I know how to write vba to change hyperlinks, but at this point if i
would have to write code, i would have to open all files and search for
hyperlinks, perhaps anyone knows a faster way to check if a file has a
hyperlink in it.
Click to expand...

There is no faster way that I know of for Word than opening the document and
then checking the value of the ActiveDocument.Hyperlinks.Count method.

I suspect that there are a similar set of options in Excel, though hopefully
an Excel expert will be along in due course to confirm.

As for Access, its a bit harder to advise. Where are your hyperlinks in
Access?


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org
 
J

jans__

Hi John,

Thanx for your reply.

In Access the hyperlinks are in tables. I know how to use vba to
replace the hyperlinks, in Word, Excel and Access. The problem is,
there are thousands of files, I think only 10% has hyperlinks in them.
I was hoping there would be an workaround to read quick if a office
files has hyperlinks in them without opening each file.
 
J

Jonathan West

Hi John,

Thanx for your reply.

In Access the hyperlinks are in tables. I know how to use vba to
replace the hyperlinks, in Word, Excel and Access. The problem is,
there are thousands of files, I think only 10% has hyperlinks in them.
I was hoping there would be an workaround to read quick if a office
files has hyperlinks in them without opening each file.
Click to expand...

There's no way I know of to find out if a document has hyperlinks without
opening the file in the application. Sounds like a batch job running
overnight. Just make sure you back up the files first.


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org
 
Top