ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Auto Select a file not knowing its specific name (https://www.excelbanter.com/excel-programming/273283-re-auto-select-file-not-knowing-its-specific-name.html)

JeffFinnan

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