| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro with drop doown box to to find name in 40 work books
I have a work book name menu with a drop down box in cell ( AB55 ) with names
in it. need a macro to find names, in work books on desk top I have 40 work books to serch in. Each Work Book Has 50 Sheets , Name Sheet1 Thu Sheet50 The names are in cell ( E14 ) If any one can help me I surley Thank You. Don PS This is the Path. Workbooks.Open(Filename:= _ "C:\Users\TQLS JIM\Desktop\DPBP AIR PROGRAM\CUSTOMERS\Customer-1.xlsb", _ UpdateLinks:=0).RunAutoMacros Which:=xlAutoOpen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to work in a 3-d reference with 2 work books | Excel Worksheet Functions | |||
| need a function that will work using multiple work books and sheet | Excel Worksheet Functions | |||
| Create a macro which can find a record in three books | Excel Worksheet Functions | |||
| Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
| Work books | Excel Worksheet Functions | |||
Threaded Mode
