batch hyperlink

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello.

in my file (Excel) there are several items (records) that are linked to
external

source files,I like to find one list that tell me each record is linked to
which external

file name.

Thanks in advanced
 
Masoud,
Is this what you mean ?

Dim HLink As Hyperlink

For Each HLink In Worksheets(1).Hyperlinks
Debug.Print HLink.Address
Next

NickHK
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

List ConnectionString of linked, external Excel file 2
Looking for some help launching files from COde & Ribbon control 0
Importing URL into Cell in Excel 0
Adding hyperlink to access database from excel 1
list box that has text that has hyperlink qualities 3
How to Change ALL Hyperlink Addresses in a Column? 8
Create hyperlinks from external links 5
Look up question from changing range with criteria 2

Back
Top