VBA Save as dialog box opening

[bliven731]

Is there a way to use VBA to open the save as dialog box, set a default name from cell information, and pick the save as file type?

Basically I want it to select sheet 3, Do file save as, default the name as (if I put quote marks I want the cell contents), "D3" "B3"-"C3" So it would be 123456 1-2019 (123456 is D3 contents, 1 is B3 contents, 2019 is C3 contents, and also make the save as file type "CSV (Comma delimited)". That is where the macro would end so that the end user could select where they actually want to save the file. It obviously has to select sheet 3 first because CSV only saves a single sheet.

The file name part is not required if that's too hard to do, the important part is selecting the file type, but the name thing would be nice if it's easy.

 

[G12]

Are you saving the macro or any other worksheets into the same file?

Also change the file format to CVS too.
ActiveWorkbook.SaveAs Filenames, FileFormat:=xlCSV

 

[bliven731]

Are you saving the macro or any other worksheets into the same file?

Also change the file format to CVS too.
ActiveWorkbook.SaveAs Filenames, FileFormat:=xlCSV

I believe that last thing fixed it. The macro and the other worksheets aren't going to be in the CSV file, they will be in a macro enabled workbook.

I'm not getting either error message after fixing that line in the code.

Thank you!