VBA Export to CSV with Specified File Name

Hi All,

I'm looking for VBA code that will export the current worksheet to a CSV file, save it in a pre-determind file path, but allow the user to enter a custom file name.

The code that I'm currently using (below), works completely fine for exporting and saving in the correct path, but the user is unable to specify a file name. Any ideas?

Please Login or Register  to view this content.

Thanks a lot richard, that worked perfectly!

One more thing, if you've got a spare minute. The sheet I'm exporting is a Pivot Table, so lines 1 through 8 are blank or filters. Is there a way I can export only the data from A9 to the end of my data?

Thanks for your help,
Dom

Hi Richard,

Thanks for the quick response. Unfortunately, as the base spreadsheet is a Pivot Table, it's preventing me from deleting the first 8 rows. I'm receiving the below error message when running the macro.

Is there a way to bypass this error and delete them anyway?

Error.PNG

Thanks,
Dom

Hi Richard,

Worked like a charm. Had to edit slightly, pasted the values in to A1 and removed the line about deleting columns A:L. See complete working code below. Thank you for all of your help.

Please Login or Register  to view this content.

Kind regards,
Dom