New
#1
Can I select a file this way?
If I have a file's full path and name on the clipboard, how can I use the Run box (or any other way) to get it quickly selected (highlighted) in File Explorer please?
Terry, East Grinstead, UK
If I have a file's full path and name on the clipboard, how can I use the Run box (or any other way) to get it quickly selected (highlighted) in File Explorer please?
Terry, East Grinstead, UK
Hi Terrypin.
Open File manager and past in bar at top of window, not search bar, the one just left.
Ken
In Run box
explorer.exe /select,c:\users\documents\test.txt
So you would open run box, type explorer.exe /select,Crtl-V(paste)
Many thanks Ken. In fact I had the same reply in the batch files newsgroup to which I posted the almost identical question:
Grant Taylor [removed] wrote:
>On 12/07/2017 07:26 AM, Terry Pinnell wrote:
>> If I have a file's full path and name on the clipboard, can I use a
>> batch file (or the Run box, or any other clever way) to get it selected
>> (highlighted) in its Win 10 File Explorer folder please?
>
>I have no idea if it's still the case, but explorer.exe used to have
>have a /select option that would open explorer and select the specified
>file.
>
>So, you could open the run dialog, type explorer /select,<Paste> and
>possibly achieve what you want.
For background, the filename itelf is in a hyperlink in Excel. I'm currently seeking help in the Excel forum on doing the whole task (from getting the link onto the clipboard, to selecting the file) in a VBA macro. I've forgotten what little VBA I ever knew a decade or so ago so this VBA approach is after my Macro Express script consistently failed at the hyperlink copying stage.
I too echo Ed's enthusiasm for this handy Run tip!
Last edited by Barman58; 08 Dec 2017 at 07:29. Reason: Remove email address
Also ...
Winkey +R and then Ctrl-V then Enter will open the file with the name and path on the clipboard - all without touching the mouse
This works because the file extension is associated with an Application, so should also work for excel sheet or file name