VBA GetSaveAsFilename not saving as .csv

Hi All,


Doing something wrong here.  On button click I am able to open the Save As window/box, enter a name, but it won’t actually save the file upon hitting Save (although the window closes).

The code is pretty straight forward:


Private Sub CmdButton3_Click()


Filename = Application.GetSaveAsFilename(fileFilter:=”Excel Files (*.csv), *.csv”)


End Sub


I am assuming that it is something to do with the file extension, but idk.


Bonus Question: Is there a way to use this so that the Active workbook doesn’t become that new saved file? (Act more like an export I guess)

By: Mike

Leave a Reply

Your email address will not be published. Required fields are marked *