I have tried a few different ways of doing this but I never get a good solution.
There has to be a simple way.
I have a Workbook. I would like create a copy on close.
This is the easy part..... I would love a prompt on close that says "would you like to create a copy now? - yes or no"
What has been the problem is, the copy version also tries to create a copy of itself. I don't want this.
The copy file should just go into a subfolder.
master file C:\Users\pike\Desktop and copy of file C:\Users\pike\Desktop\backup\