Hyperlink to open folder location (and select / highlight file)

[n0c0re]

Hi,

I am using Excel 2007 on Windows 7 64-bit.

When you search for a file in Windows 7, you can right click and select "Open folder location". This will launch a new window of Explorer and open the folder that the selected file or folder is located in, AND select / highlight the selected file or folder.

Is there a way to do this in Excel?.

I'd like to make a macro to generate these types of links. See pic for example.

Thanks in advance.

 

[Tinbendr]

You really don't need a macro.

=HYPERLINK(D5 &  "\" & C5,"CLICK HERE")

Look at the help file. You can even jump to a specific cell location.

 

[n0c0re]

Sorry if I wasn't clear enough in my post.

I want to click the hyperlink such that Windows Explorer is launched, opened to the folder in column D, and highlight (but not open) the file specified in column C.

Now that I think about it some more, perhaps I need to launch Explorer.exe with some parameters?

Regards.

 

[n0c0re]

Okay I'm pretty it can't be done with a hyperlink as you can't pass switches/parameters with a hyperlink.
I would need a macro and I can't afford to generate a different macro for every single line.