Creating Macro that will save a copy of the workbook to new directory + make it an add in

Hi all,

I need a macro that will save a file in a specified directory such as

C:\Users\Bryan\Desktop\Folder

and it will save it with the name "Timesheet" followed by todays date: such as Timesheet9/8/2012
the code i am using now seems to move the workbook completely, when i am trying to keep the workbook and save a copy of the completed timesheet into a different folder.
This is what I currently have

Please Login or Register  to view this content.

I also want to make this macro an add in, so that others can add it to their ribbon in order to run this macro, I have had horrible attempts at making a macro an add in.


Any help appreciated

Thanks,
BeachMaster

thank you! feel dumb now :/ though, haha.

any links/advice on making macro into an AddIn?