Solved: open xlsx file with part of name

[dani9]

HI,

I have this file name: "April 2011 Ref Data" and the first part (April 2011) will be changed every month.

So I am trying to use a wildcard to open it. This is what I have so far:

[VBA]Workbooks.Open (ThisWorkbook.Path & "\" & "*" & "Ref Data.xlsx")[/VBA]

Any ideas why it is not working??

[Kenneth Hobs]

[vba] Dim xlsx As String
xlsx = ThisWorkbook.Path & "\" & Format(Date, "mmmm yyyy") & " Ref Data.xlsx"
Workbooks.Open xlsx[/vba]

[dani9]

[vba] Dim xlsx As String
xlsx = ThisWorkbook.Path & "\" & Format(Date, "mmmm yyyy") & " Ref Data.xlsx"
Workbooks.Open xlsx[/vba]

This is searching August, but i need it to search for previous month - July for example, because I don't have data for the current month.

[dani9]

Got it!

[VBA]xlsx = ThisWorkbook.Path & "\" & Format(DateAdd("m", -1, Date), "mmmm yyyy") & " Reference Data.xlsx"[/VBA]

Thanks a lot, Kenneth!!