Saving Excel workbook to constant path with filename from two fields

Question

I tried to search and put together a code to fit my purpose   Sub save   ActiveWorkbook SaveAS Filename   C  -docs cmat Desktop New folder ck xls   FileFormat       xlNormal  Password      WriteResPassword      ReadOnlyRecommended  False       CreateBackup  False End Sub   How to edit this to  Instead of naming the saved file ck xls  generate the filename from the worksheet cells C5 and C8  with a space in the middle

User · Answer

Ok  at that time got it done with the help of a friend and the code looks like this   Sub Saving    Dim part1 As String  Dim part2 As String   part1   Range  C5   Value  part2   Range  C8   Value   ActiveWorkbook SaveAs Filename       C  -docs cmat Desktop pieteikumi    amp  part1  amp       amp  part2  amp    xlsm   FileFormat     xlOpenXMLWorkbookMacroEnabled  CreateBackup  False  End Sub   How do I edit this part  FileFormat        xlOpenXMLWorkbookMacroEnabled  for it to save as Excel 97-2013 Workbook  have tried several variations with no success  Thankyou  Seems  that I found the solution  but my idea is flawed  By doing this FileFormat        xlOpenXMLWorkbook  it drops out a popup saying  the you cannot save this workbook as a file without Macro enabled  So  is this impossible

User · Answer

try   Sub save   ActiveWorkbook SaveAS Filename   C  -docs cmat Desktop New folder    amp  Range  C5   Text  amp  chr 32   amp  Range  C8   Text  amp   xls   FileFormat       xlNormal  Password      WriteResPassword      ReadOnlyRecommended  False      CreateBackup  False End Sub   If you want to save the workbook with the macros use the below code  Sub save   ActiveWorkbook SaveAs Filename   C  Users    amp  Environ   username    amp          Desktop    amp  Range  C5   Text  amp  Chr 32   amp  Range  C8   Text  amp    xlsm   FileFormat         xlOpenXMLWorkbookMacroEnabled  Password  vbNullString  WriteResPassword  vbNullString        ReadOnlyRecommended  False  CreateBackup  False End Sub   if you want to save workbook with no macros and no pop-up use this  Sub save       Application DisplayAlerts   False     ActiveWorkbook SaveAs Filename   C  Users    amp  Environ   username    amp          Desktop    amp  Range  C5   Text  amp  Chr 32   amp  Range  C8   Text  amp    xls         FileFormat  xlOpenXMLWorkbook  CreateBackup  False     Application DisplayAlerts   True End Sub

[excel] Saving Excel workbook to constant path with filename from two fields

Examples related to excel

Examples related to vba

Examples related to save