After reading threads, I have realized you cannot change the File Format using the SaveCopyAs Filename syntax. How do I get around this? I have created a command button that is creating a folder on my computer, saving my current macro enabled file as a .csv and everything is working...however, it changes the current workbook file name instead of creating a copy and it changes the tab name in the workbook to the new SaveAs file name. Any tips are much appreciated?
Here is my current code below:
Sub SaveCSV()
'
' SaveCSV Macro
'
ChDir "C:\VSA\ForecastComments"
ActiveWorkbook.SaveAs Filename:= _
"C:\VSA\ForecastComments\2017 FC Comments-" & Worksheets("Summary").Cells(1, 2).Text & " " & Worksheets("Summary").Cells(2, 2).Text & ".csv", FileFormat:= _
xlCSV, CreateBackup:=False
End Sub
Here is my current code below:
Sub SaveCSV()
'
' SaveCSV Macro
'
ChDir "C:\VSA\ForecastComments"
ActiveWorkbook.SaveAs Filename:= _
"C:\VSA\ForecastComments\2017 FC Comments-" & Worksheets("Summary").Cells(1, 2).Text & " " & Worksheets("Summary").Cells(2, 2).Text & ".csv", FileFormat:= _
xlCSV, CreateBackup:=False
End Sub