VBA macro to export specific range of cells to CSV

Hey everyone,

I am trying to export specific range of cells from excel sheet to CSV. In my case it should start from Row 3 and stop with last row and columns should be A:G

I am pretty amateurish with VBA so most of things I google and compile yet, but im stuck at this moment.

Ive got below macro but it exports whole sheet and I need to skip first 2 rows and stop at column G.

Thank you guys in advance

Please Login or Register  to view this content.

Hi thank you, it returned an error for the row " Rows("1:2").Delete "

Anyways, meanwhile I found your code (below) in another topic which gives me csv export for cell range I choose, which is great. But I would like to change the path and filenames for exports generated:
Is there a way to create new folder in a specific path so It places the file in folder for current date (ddmmyyyy) or it creates one if there is none?
Can the file be named based on a specific cell in excel?

Please Login or Register  to view this content.

figured it out find below how I updated the code

Please Login or Register  to view this content.

I have one more question to this topic..

Is there a way to improve my macro to export only values in csv? in some cells there are formulas and it will export #values error..

Thank you!