Incremental Hyperlinks in Excel
Is there a way to add incremental hyperlinks in excel? I have 2,000+ drawings that I need to add a hyperlink to each one in a document. So each row would have a link to a specific drawing but all the drawings are in the same folder? Is there a way to do this without having to link one by one?
Hi, welcome to the forum
what does your HL formula look like?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi and thank you!
Right now its file:///E:\Documents\filename.pdf.
I have all the files in order in the same folder as the excel spreadsheet I just don't want to have to go and manually link each drawing.
are the file names consecutive in any way?
some examples?
Yes and No. Each file name is the drawing number so it varies. Here's some examples:
74336-001.pdf
74336-002.pdf
74336-84-000.pdf
B-084-XXX-XX-0000.pdf
D-084-000-XX-0000.pdf
D-084-XXX-XX-0000.pdf
The X's are different values depending on the location for that drawing.
Last edited by HQJ; 03-02-2015 at 05:06 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks