Open Everything from Excel Hyperlink

General discussion related to "Everything".
Post Reply
MattZ
Posts: 2
Joined: Wed Feb 01, 2023 2:22 am

Open Everything from Excel Hyperlink

Post by MattZ »

The company I work for currently uses this software to help assist in sending files out to suppliers. In Excel is it possible to create a hyperlink to Everything under the "All Files" column referencing the PN column?
Excel Screen Cap.PNG
Excel Screen Cap.PNG (14.93 KiB) Viewed 1132 times
Ideally this opens Everything with the PN in the search box.
Excel Screen Cap2.PNG
Excel Screen Cap2.PNG (6.06 KiB) Viewed 1132 times
Would clicking a second hyperlink launch another session of Everything or could it copy the new Part Number (PN) into the current session search box?

Thanks,
Matt
void
Developer
Posts: 15351
Joined: Fri Oct 16, 2009 11:31 pm

Re: Open Everything from Excel Hyperlink

Post by void »

Please try enabling the Everything URL Protocol:
  • In Everything, from the Tools menu, click Options.
  • Click the General tab on the left.
  • Check URL protocol.
  • Click OK.
Everything will now open with es: URLs.

For example:

002770P1
es: URL Protocol
MattZ
Posts: 2
Joined: Wed Feb 01, 2023 2:22 am

Re: Open Everything from Excel Hyperlink

Post by MattZ »

Void,

I was able to get it to open with the following command

=HYPERLINK("es:"&J18, "Click Here")

Thanks,
Matt
Post Reply