Adding wildcards to Workbook.open filenames

Hi -
I've got my project working now with help I've been able to gleen from the forums. Its been very helpful. I do have one problem that will come up in the future and I'd like to take care of it now. So here goes -

I'm copying worksheets from one workbook into a newly created workbook. My problem will be that the CopyFromWorkbook's filename will change when it is revised because the revision number is in the filename. In DOS days I would have used "??" to wildcard the revision number. Is there a way to create a filename that would do the same thing?? I'm currently building the filename string and using that with workbooks.open, but I can "hardcode" it in if necessary.

Thanks for the help!!

Mark

Mark

It isn't possible to use wildcards with Workbooks.Open.

You can however use them with the Dir command.

strFileName = Dir("C:\Test??.xls")

Workbooks.Open strFileName