Export CSV file in Specific naming format

[momer]

Hi, I have the below code SaveFileAs that's saving the file with a specific format and I would like to export the file in CSV format and I do have the below code for it, however is there any way to merge the CSV mcro in SaveAs or provide the specific format while Saving CSV macro.

The output has to be in certain format and with 2 of the below code, I am unable to save it as one file.

Any help would be greatly appreciated, Had been stuck for sometime

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[momer]

I am trying to insert a variable filename under first doubt quotes(filename),although not sure if it takes variable.

Please Login or Register  to view this content.