Can I use Hyperlink to open Folders?

N

Neil in NZ

Hi,

I have a spreadsheet (excel 2007) with 1000+ records.
Each record is numbered in Cells Column A.
Each record refers to a "job" undertaken.
Eg. Record #6472 = Job 6472-Cast Components.
Eg. Record #6473 = Job 6473-Machined Components.

Each "Job" is saved in a folder.
Eg. "E:\Enquiries\6400-6400\6472-Cast Components".
Eg. "E:\Enquiries\6400-6400\6473-Machined Components".

How can I write 1000+ Hyperlinks to open the Folders from the spreadsheet?

I have tried the following-

=HYPERLINK(CONCATENATE("E:\Enquiries\",LEFT(A165,2),"00-",LEFT(A165,2),"99\",A165),"Open Folder")

Cell A165 Contains "6472"

The above formula will return the path "E:\Enquiries\6400-6400\6472" and I
though I could use a wildcard "*" to accomodate the "-Cast Components" part
but it does not work

=HYPERLINK(CONCATENATE("E:\Enquiries\",LEFT(A165,2),"00-",LEFT(A165,2),"99\",A165,"*"),"Open Folder")

The above formula will return the path "E:\Enquiries\6400-6400\6472*"

Thank You in Advance,

Neil
 

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

Hyperlink to folder only brings up Explorer's Folders view 0
Can you determine if hyperlink points to empty folder? 4
dynamically change hyperlink address on form 7
Adding hyperlink to access database from excel 1
How can I open an Excel workbook using a cell containing the path and filename 2
Form Hyperlinks to PDF only work for user who inputed hyperlink 0
How can I add A Hyperlink to a file in public folders 0
How do I Hyperlink to document using filename in cell? 3

Top