VBA Using Windows Desktop Search

Hi All,

Can someone help if possible?

I would like to be able to call a windows 7 desktop search from VBA and pass search and path parameters to the query.

I can issue the commands separately

This will bring up a Win7 Desktop search with Search Word searchwin set

searchwin = "SO6515"
Call Shell("explorer ""search-ms://query=" & searchwin, vbNormalFocus)

This will bring up Win7 Desktop search with Path Parameter pathwin set

pathwin = "C:\Bulletins"
Call Shell("explorer " & pathwin, vbNormalFocus)


but I cant find a way to combine both the Search term and Path in one query

I would like something on the lines of

searchwin = "SO6515"
pathwin = "C:\Bulletins"
Call Shell("explorer " this path pathwin and this search term searchwin )

Is this possible or is there an alternative I can use from VBA as I want to assign this to a button.

Appreciate any help.

Hi JosephP,

I cant thank you enough I was experimenting and searching for practically 2-3 hours and no where did I find the "&crumb=location:" keyword that you added. Where do you know something like that, lol.

Brilliant, worked perfectly!!

This is the code which i can't use in windows xp.
Could you please tell me for windows xp?

Originally Posted by JosephP

perhaps

Please Login or Register  to view this content.

Could you please help with How do I create Hyperlink to the location of the Searcched file ?