• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Save as a macro enabled workbook

dparteka

Member
I have this macro that works perfectly except that it saves my macro enabled workbook (xlsm) as a regular excel workbook (xlsx). Can someone tell me what I need to change so it saves my macro enabled workbook as a macro enabled workbook?

With Application.FileDialog(msoFileDialogSaveAs)
.AllowMultiSelect = False
.InitialFileName = ("H:\Public\") & Range("AJ2").Text & " QCR"
If .Show = -1 Then .Execute
End With

Thank-you... Dennis
 
Back
Top