VBA/Macro Code needed to open 'Save As' dialogue box and set the file type to CSV

Hi,

I need some code to help me with a template at work. When the user clicks the macro button the last action I need it to do:

1. Open the 'Save As' dialogue box (at a pre-determined folder) so the user can set the file name to be saved.
2. Change the 'Save As Type' to - CSV (Comma Delimited) (*csv)

The only code i've got to work at the moment, does the above but without letting me choose my own filename, it just saves it current filename.

Thanks in advance
Dale
Using Excel 2007

Hi Norie,

Thanks for your help. The code works and saves the file, but when i go to the chosen folder on the hard drive the file i saved isn't there.

I had this issue before and wondered if it was to do with the file type in the code ie "CSV File"

When you manually save the file and use the drop down option "CSV (Comma Delimited) (*csv)" the file saves and is in the folder.

Is it possible to put in the code to select "CSV (Comma Delimited) (*csv)" as the file type?

Hope that makes sense

Thanks
Dale

Hi Norie,

I don't need the code to actually save the file. The user will manually click save once they've chosen the filename, it's just there seems to be an issue with the file format in the code as the saved file doesn't appear in the file directory.

Any ideas?
Dale