Hi,
I have macro that creates a new workbook based on a sample sheet within the workbook containing the macro. The macro names the file with a correlative number (based on the value of a cell that increases by one everytime a new workbook is created). So, for example, the first file created will have the name "name 1.xlsx", the second "name 2.xlsx", the third, "name 3.xlsx" and so on.
I'd like to have a separate macro that deletes the last workbook created so that if the user made a mistake when creating a file, say file "name 13.xlsx", he could run this macro and have it deleted. I can't figure out how to tell the macro that the name of the file is "name (cell value).xlsx". "Cell value" being the correlative number of the last workbook created. Is this even possible?
Thanks in advanced
Bookmarks