![]() |
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 |
All times are GMT +1. The time now is 10:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com