Help Please with Macro

[Dangstupidtrainee]

Folks,
Please help me on this one. Ive read several threads and seen many instances that were close to what I need, but no prize as yet.

For my job I have to complete a daily job brief. I have created that brief as an excel spreadsheet since that is much easier than paper in my truck. The spreadsheet has been saved as a template named "Routine Job Brief".

I need a macro that can save a copy of the completed brief, using the date as a file name, to a folder on the desktop labeled Routine Job Brief.(Would it be possible to create a macro that can do all of this and also clear the entries made on the template after the save?)

Any help would be GREATLY appreciated!

 

[alansidman]

An alternative is to take your template and save it as a template with no data in it. Each time it is opened it will open with no data.

Excel Templates - Easy Excel Tutorial

 

[Dangstupidtrainee]

An alternative is to take your template and save it as a template with no data in it. Each time it is opened it will open with no data.

Excel Templates - Easy Excel Tutorial

Wow, that is a really impressive comment! By the way, per my initial post, i already have it saved as a template.....Thanks for ignoring my post and request.

 

[Michael M]

You'll get more flies with honey, than you will with vinegar !!!

I don't have Excel at the moment but...

Try this ... UNTESTED

Public Sub SaveToDesktop()
    ThisWorkbook.SaveAs Filename:="C:\Users\Public\Desktop\" & ThisWorkbook.Name & Format(Date, "dd/mm/yyy") & ".xls"
End Sub

 

[jtakw]

Wow, that is a really impressive comment! By the way, per my initial post, i already have it saved as a template.....Thanks for ignoring my post and request.

You live up to your screen name, read Alan's post again.

 

[Dangstupidtrainee]

You live up to your screen name, read Alan's post again.

Maybe i do, but i know how to read and comprehend a post.....the best you can do is jump in to make snarky remarks without helping a situation....

.

 

[Michael M]

Did you try the code ???

 

[Dangstupidtrainee]

Did you try the code ???

Not yet....will do so in a few hours when i return home.....Thank you so much for taking the time to try and help!