Hi,
Do you know how to export multiple worksheets in an excel workbook to individual csv files in a folder using VBA excel? I am current using excel 2010.
For example I have 50 worksheets (sheet1, sheet2, sheet3...., sheet50) in a excel workbook file. Click the button "Browse and export" to run the macro, ask you where you want to export , browse file directory and select the folder then all csv files export in that folder. Note the csv file name of csv file should be same as the individual worksheets. e.g. sheet1.csv, sheet2.csv, sheet3.csv….., sheet50.csv.
Thank you.
Bw
Mr Singh
Do you know how to export multiple worksheets in an excel workbook to individual csv files in a folder using VBA excel? I am current using excel 2010.
For example I have 50 worksheets (sheet1, sheet2, sheet3...., sheet50) in a excel workbook file. Click the button "Browse and export" to run the macro, ask you where you want to export , browse file directory and select the folder then all csv files export in that folder. Note the csv file name of csv file should be same as the individual worksheets. e.g. sheet1.csv, sheet2.csv, sheet3.csv….., sheet50.csv.
Thank you.
Bw
Mr Singh