Export all data ion sheet BR1

[howard]

I have a sheet called BR1. I would like a macro to export this sheet as a CSV file "Called BR1 Div.csv" and must be saved to a directory called dividends


Your assistance in this regard is most appreciated

 

[Joe4]

This is actually pretty easy to do yourself.

Just turn on the Macro Recorder, and record yourself going to that sheet and saving as a CSV file to the directory and name that you like. Then stop the Macro Recorder. You will then have the code that you need to do this.

 

[sdsurzh]

Hi,

Try the below code.


After ABC to Desktop please change your domain and folder name.
Sub saveascsv()
ActiveWorkbook.SaveAs Filename:="C:\Documents and Settings\ABC\Desktop\BR1 Div.csv", FileFormat:=xlCSV, CreateBackup:=False
End Sub


Thanks,
SK

 

[howard]

Hi Joe

Thanks for the reply. I have several sheets. I only want to export the sheet BR1

 

[Joe4]

By default, when you do a SaveAs to any text file format (like CSV), it only lets you do one page!
So even if you have 100 pages in your workbook, if you do the steps I told you, you will only be exporting the page that you are on when you run it.

 

[howard]

Hi Joe

Thanks for the help. I have tried recording the code and it works

 

[howard]

Hi Joe

Thanks for the help. I have tried recording the code and it works

 

[Joe4]

Thanks for the help. I have tried recording the code and it works

Great! And you learned a little programming trick to boot!

Even for tasks that are more complicated, you can start a lot of VBA code by using the Macro Recorder by getting some base code, and building on to it.