How to open a workbook with partial Name?

[ananthakumar.e]

Hi all,

I need a help from you.In VBA how to open a workbook for which i know only the partial name?
E.x April_2008.xls .How to open this workbook with the parital Name "April"?

Thanks in advance.

[Leith Ross]

Hello ananthakumar.e,

Since you can't open a workbook without knowing its full name, you would need to search a directory for all files that match "April" and then manually select the file you want to open. There is no built in file function to filter file names using wild card characters. The easiest approach is display the directory using Application.GetOpenDialog and search for the file you want. Creating all the VBA routines to do the filtering, constructing a user interface, and selecting the file is probably not worth your time in the end.

Sincerely,
Leith Ross