| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Select a file not knowing its specific name
Dim WB As Workbook
For Each WB In Workbooks If WB.Name Like "Export*" Then WB.Activate Exit For End If Next WB ======================== Chip, It did the trick. Thanks a bunch. Jeff |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| select file from which to extract specific data | Excel Discussion (Misc queries) | |||
| Select specific column for auto filter | Excel Worksheet Functions | |||
| Hyperlink to a file without knowing its extension | Excel Discussion (Misc queries) | |||
| Link to specific cell in specific Excel file | Excel Discussion (Misc queries) | |||
| I need a specific value in auto filter to fill a combo box and than match the select value in 2 other columns. | Excel Worksheet Functions | |||
Linear Mode
