I IceFrogBG Member Mar 15, 2018 #1 Hi all, Anyone can help me how to use search-ms. I copied code from internet but it doesn't work. Please see my file for detail and support me. Thanks all. Code: RetVal = Shell("c:\Windows\explorer.exe"" ""search-ms:query=080023CE2A62 &", vbNormalFocus) Attachments MS search.xlsx 218 KB · Views: 6
Hi all, Anyone can help me how to use search-ms. I copied code from internet but it doesn't work. Please see my file for detail and support me. Thanks all. Code: RetVal = Shell("c:\Windows\explorer.exe"" ""search-ms:query=080023CE2A62 &", vbNormalFocus)
Hui Excel Ninja Staff member Mar 15, 2018 #2 Icefrog What do you want to happen? Do you want an Explorer window to open or a list of matching items ? If you want an explorer window use: retval = Shell("explorer.exe " & Chr(34) & "search-ms:query=*.pdf&crumb=location:c:\" & Chr(34), vbNormalFocus) If you want a list, have a read of: https://technet.microsoft.com/en-us/library/ee692883.aspx
Icefrog What do you want to happen? Do you want an Explorer window to open or a list of matching items ? If you want an explorer window use: retval = Shell("explorer.exe " & Chr(34) & "search-ms:query=*.pdf&crumb=location:c:\" & Chr(34), vbNormalFocus) If you want a list, have a read of: https://technet.microsoft.com/en-us/library/ee692883.aspx