I have set up a fuel logging spreadsheet with a button. I am trying to write a macro that will then save my spreadsheet to my D drive with a default name and date from a specific cell.
i.e the file name is "Edwinas Fuel Log". I want the file to save to my "D" drive with the file name "Edwinas Fuel Log - dd-mmm-yyy". This date would be retrieved from cell B4 on the spreadsheet.
My apologies if i am not explaining myself properly but I have tried all sorts of things but everything comes back with an error and its' driving me crazy.
Any help would be very much appreciated.
Thanks in advance
Paul
Bookmarks