Creating a csv file with extract from excel

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I need to extract data in a sheet called csv (A1:H6) in my excel workbook into a new csv file with a new name.

The new name is generated based on data entered in a cell a1.

Also I want the original file to be saved with the same name just .xls in stead of .csv.

The Macro needs to be run either by pushing a button or entering a certain value in a cell ie. A10.

Can anyone help.

Thanks,

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Could you upload to a file sharing site a sample file with sample data and and re-explain your requirement using that sample file as reference