Ron thanks for the info, these macros work great.

The only thing I need to do is have it reference a Cell in the workbook for
the filename. This is a workbook that has fiscal months and a tab for each
week. The weekly needs to be separated out and saved in a specific format ie
ZWatts 3-17 to 3-23. I have a cell programmed with the appropriate filename
format but am unable to get it to reference.

Thoughts? Is this possible?

"Ron de Bruin" wrote:

Hi ZWatts773

Read the info on this page
http://www.rondebruin.nl/saveas.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ZWatts773" wrote in message ...
I am trying to export 1 sheet to a new workbook with a specific save as
filename. The filename is created by the excel worksheet in a specific cell.
The issue I have now is getting Excel to save the file as an excel workbook.


The following code works except it does not specify file type:

Dim vSaveWeekly As String
vSaveWeekly = Application.GetSaveAsFilename(Worksheets("Week
1").Range("G1"))
If vSaveWeekly = "False" Then
Exit Sub
End If
Application.ThisWorkbook.SaveAs vSaveWeekly

When I add in the file filter I get: "Compile Error: Expected List
Separator or )"

I programmed it as this:
vSaveWeekly = Application.GetSaveAsFilename(Worksheets("Week
1").Range("G1"),"Excel Workbooks *.xlsm)"
,*.xlsm)

Please help, I just need the program to save the file with the specified
name which will always be in the referenced cell, and it needs to be saved as
an Excel 2007 file.