Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Possible ? Search all closed workbooks in a folder
Is this Possible ?
To Search all closed workbooks in a designated folder and copy worksheets to another workbook, if combo box values are matched. I have a userform with 2 comboboxes on it(related) where the 2nd combobox is dependant on the 1st combobox value in a smae worksheet. I want to place this in a workbook named (FIND Sheets) and run this as a macro to search through all the closed workbooks in a particuar folder, Then all the found worksheets that have the values in both comboboxes, to be copied and placed intot he FIND Worksheets workbook ? There could be as many as 10 workbooks in the folder. Can it be done ? Corey.... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying From Closed Workbooks | Excel Worksheet Functions | |||
Where is the closed folder button in Excel? | Excel Discussion (Misc queries) | |||
Perform code on all (closed) workbooks scattered across sub-folders of common parent folder | Excel Programming | |||
Search Macros in closed file | Excel Programming | |||
get data from closed workbooks! | Excel Programming |