I have the following formula.
It works for saving as a new workbook. How can I get it to work for saving as CSV?
I have tried adding ".csv", FileFormat:=xlCSV to it but no such luck thus far.
Cheers![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
It works for saving as a new workbook. How can I get it to work for saving as CSV?
I have tried adding ".csv", FileFormat:=xlCSV to it but no such luck thus far.
Cheers
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
Code:
ActiveWorkbook.SaveAs Filename:="C:\User\Test.CSV" & Test1Str & " " & TestStr & " " & ActiveWorkbook.Name