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.

Please Login or Register  to view this content.