Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find file that starts with todays date
and activate
this is what i have For xxx = 1 To Workbooks.Count If xxx.Name Like Format(Date, yyyymmdd) & .csv Then xxx.Activate End If Next xxx thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
find file that starts with todays date
Try the below
For Each wb In Workbooks If wb.Name Like Format(Date, "yyyymmdd") & "*" Then _ wb.Activate: Exit For Next If this post helps click Yes --------------- Jacob Skaria "LuisE" wrote: and activate this is what i have For xxx = 1 To Workbooks.Count If xxx.Name Like Format(Date, yyyymmdd) & .csv Then xxx.Activate End If Next xxx thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save file as todays date | Excel Discussion (Misc queries) | |||
Save file with todays date ref#11235 | Excel Worksheet Functions | |||
Excel 2000 - find todays date | Excel Discussion (Misc queries) | |||
Insert Todays Date - 3 in file name | Excel Programming | |||
Saving a file with todays date on the end | Excel Programming |