Thread
:
Auto Select a file not knowing its specific name
View Single Post
#
1
Posted to microsoft.public.excel.programming
JeffFinnan
external usenet poster
Posts: 9
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 With Quote
JeffFinnan
View Public Profile
Find all posts by JeffFinnan
Auto Select a file not knowing its specific name