Hi All,

I am aware of how to save a sheet as a CSV file from a Macro.

What I am attempting to do is to save a sheet as a .apa file.

I am using the current code to save as a CSV:

ActiveWorkbook.SaveAs stFileNameCSV, FileFormat:=xlCSV, CreateBackup:=False
Is there a way to make it save as .apa?

Any help will be greatly appreciated.