Modify macro to save with current file name and date

I am placing a macro in excel to save a file to our network. It works but it always saves it as a fixed document name. I would like to modify it so I can use it in a blank template. I would like to have the macro save the file under what ever the current document name is with the date the file was saved.

Please Login or Register  to view this content.

I wouldn't expect to save as *.xltm but *.xlsm" or *.xlsx

Please Login or Register  to view this content.

Try

Please Login or Register  to view this content.

You are saving as a template file though

You really have the wrong file format, have you tried .xlsx?

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

I had an additional question to add to this thread and I hope I can explain what I want to do clearly. I would like to see if I can make the macro look for a directory typed into a cell in the work book on where to save the file on the network drive. Thank you royUK for helping me the date and name previously on this macro.

Say I have some cell (B:9) that has one of the follwoing locations on the netowrk I want to save the file to.
Example
K:\OPERATIONS GEO\Backup of Cross Sections\project 1\
or
K:\OPERATIONS GEO\Backup of Cross Sections\project 2\

can I get the macro reference the cell (B:9)?

Please Login or Register  to view this content.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Also - please don't create never-ending threads. If you have a new question, start a new thread.

Thanks!

You need to read about Variables & how to use them

Please Login or Register  to view this content.