I'm looking for some code that will open a csv file on a daily basis that has the same prefix but the last part of the filename changes. The last part of the filename is the current date, in mmdd format e.g. 0322
What I have tried so far has failed dismally, can anybody help?
Workbooks.Open FileName:= _
"C:testtest01 " & text(Date"mmdd") & ".csv"
thanks
Matt
What I have tried so far has failed dismally, can anybody help?
Workbooks.Open FileName:= _
"C:testtest01 " & text(Date"mmdd") & ".csv"
thanks
Matt