Saving workbook using part of a file name

[vavs]

I have a workbook that is created every month and the name changes month to month. I have a macro stored in the workbook that creates new tabs and saves them. I can save and close these workbooks relatively easily. I want to be able to close the main workbook, but the name will change so I cannot close using the workbooks("workbookname").close function. Is there a way to add a wildcard to the name to allow me to close when the processing is done? Is there an option to save and close?

 

[Norie]

Where is the code that you want to close the workbook from located?

If it's in the workbook itself you can use ThisWorkbook.Close to close it.

 

[vavs]

I am going to try that. Excellent suggestion.