In the excel worksheet, I want to be able to record a macro so that everytime I hit 'control a' it saves the file as 'Cancellation Filing RR ###'. The ### are where I would like it to go to the next number. The file name is not found any where in the worksheet.
The folder location is y:/Dellserver/Newdell d/Users/rhagos
Oh by the way, what's the easiest way to learn VBA on my own so I don't have to keep relying on you guys in the forum. Ya'll do an excellent job, but I'd like to do this myself. Thanks