Actually on the save part I would like to take it a little further. I want the file by default to automatically save to C:\profit folder without any macros attached to it. I want the name of the file to be the content of the last cell in column A which will have a varying number of rows.
I am using this code to save my file, however, the last cell in column A: is a Date thus it gives me an error. How can I convert let say 9/25/06 <-- this date varies every time you run it. To 9.25.06 or 9-25-06 or September 06.
In this example the last cell in my sheet is 9/25/2006 so basically right now it is looking for a forder C:\test\9\25 and save is as 2006.xls.