elmnas
06-05-2015, 12:17 AM
Hello all Members,
I have made following code below
The script search for a file on a certain path,
How do I make the script select the folder and open it when found?
http://www.excelforum.com/clientscript/select_all_icon.jpg http://static.beckelman.net/v1/img/page_white_copy.png
searchwin = "34228"
pathwin = "X:\XXX\XXX\XXX\"
Call Shell("explorer ""search-ms://query=" & searchwin & "&crumb=location:" & pathwin & """", vbNormalFocus)
Thank you in advance
I have made following code below
The script search for a file on a certain path,
How do I make the script select the folder and open it when found?
http://www.excelforum.com/clientscript/select_all_icon.jpg http://static.beckelman.net/v1/img/page_white_copy.png
searchwin = "34228"
pathwin = "X:\XXX\XXX\XXX\"
Call Shell("explorer ""search-ms://query=" & searchwin & "&crumb=location:" & pathwin & """", vbNormalFocus)
Thank you in advance