ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Launching Windows Search application from Excel macro (https://www.excelbanter.com/excel-programming/444041-launching-windows-search-application-excel-macro.html)

[email protected]

Launching Windows Search application from Excel macro
 
I would like to open a windows search from XL VBA. For example, after
I type "MNU01" in column "E", I'd then like to launch a windows
search for all emails with "MNU01" in the subject line.

I am familiar with how to make code execute when something is typed
into a certain range of cells -- i.e. Private Sub
Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("E12.E6500")) Is Nothing Then) --
however I need help understanding how to open windows search from VBA
(and how to send the search parameters). Any help is appreciated.

I'm using Windows XP and Excel 2007.






All times are GMT +1. The time now is 10:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com