Save a Macro Enabled Template to a custom location with a custom file name.

If I had that much time and understanding of excel and vba I wouldn't have asked for help.
And I am not using it blindly, I edited what I thought was logical. Ultimately, what harm can the above macro do to my PC?

Could you please care to elaborate "Do not Copy VBA"

Anand

Originally Posted by royUK

What snb means is that we are here to help people learn to use Excel, not do the work for them.

I am sorry if my original post portrays that I am here to get people work for me.

I had problem completing certain task, searched about that problem, landed over to http://www.excelforum.com/excel-prog...-template.html, tried to make it work for me, it didn't and after your suggestion I started a new thread, that's it
Isn't that's what forums are for... to help and get help. Even I am a member of lot of forums where I help people if the their posts falls under my area of expertise, I don't ask them to read books.

Anyways, If you still think I am asking for something unjustified, you are most welcome to delete the thread.

Hi Roy
I greatly appreciate and thank you for all your efforts. The code given by you is simple yet very straight forward and works like a charm.
Meanwhile, I figured out the problem and got the previous code working too, by replacing "xlOpenXMLWorkbook" in the 8th line with "xlOpenXMLWorkbookMacroEnabled"..

Sub saveFileMacro()
FullFileName = Application.GetSaveAsFilename("D:\2012\Invoice\" & Format(Range("K3").Value) & ".xlsm", _
    "Excel Macro-Enabled Workbook (*.xlsm),*.xlsm", 1, "Save File As")
If FullFileName <> vbNullString Then
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs Filename:= _
        FullFileName, FileFormat:= _
        xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
ActiveWorkbook.Close
Else
MsgBox "File not saved"
End If
End Sub

As for saving with the macro, the template file contains another macro which enables few extra functions which are required to display certain fields and do some calculations, so when I save it as a normal file, those functions doesn't work.

Anyways, Thank you so much.

Anand

You're right, it won't need any changing, but it will help me avoid copy pasting a lot of data if I am billing to another company with same products. Will run the macro again from that sheet and new invoice will be created.

I was looking for the same answer as the original questioner, and I was shocked by the snide, unhelpful answers. You must feel compelled to demonstrate your superiority. I mean, if somebody has an honest request for help (such as, in this case: the user had tried to use code found on the web, but was getting an answer he/she didn't understand), then either try to help him out, or don't answer. Your aggressive, repulsive tone didn't help in any way, so why waste your time? You may reign supreme in your role as an Excel guru, but try remembering that other people are actual human beings, and, being human, expect a certain built-in level of grace and courtesy from other human beings.