Delete excel files in a given folder

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

please, paste here your code

Hi, patel45.

I don't have a code yet for deleting the file. The macro I want would be separate from the macro that creates the file. All I want it to do is look for the last file created (using the correlative number found in cell A2) and delete it.

If it helps. This is the code that creates the file:

Please Login or Register  to view this content.

I know it's a crazy looking and messy code. I really have no training in VBA at all, all i know, I've learned along the way.

As I said, I need the macro that deletes the file to be separate from this one. What I really don't know how to do is give the macro a varying file name (based on the value of the cell [A2] containing the correlative number)

Thanks

Hi, adrianrff,

maybe something like this (you need to change the name of the sheet and range as well as the location to suit):

Please Login or Register  to view this content.

Ciao,
Holger

Thanks, HaHoBe!

Worked like a charm.

I struggled at first because I'm not familiar with ThisWorkbook.Path format. I failed to realise that ThisWorkbook.Path meant "This workbook's path", duh! I kept typing the whole path and, of course, it couldn't find the file.

Thanks again.