macro to save file to specific folder with file name from cell reference

Hi there.
I need a code to save a file to a specific folder with the name - 'Invoice Sheet' and then the value from cell 'C11'.

I want the file to save to C:\Users\Jeff\Documents\Dad 2013 as a macro enabled file

Any help would be greatly appreciated.

Thank You this worked perfectly :-)

Hi all, trying to do the same thing...save a file with the name specified in a certain range of cells. I have obtained the following code from somewhere else on the intertubes:

Please Login or Register  to view this content.

The code is in the ThisWorkbook and click the save button. Excel asks where I want to save it and populates the file name as specified in the sheet "CPM", range "N1" as desired. Unfortunately it has "Excel Workbook" specified as a type of file. I need to change this to default to Macro Enabled Workbook.

My question: How do I do this???????

Thanks in advance!


M

@cactusman
As per forum rules, do not hijack someone else's thread. Start your own please