C
cyew
Hi
I am new to VBA.
I have data on a number of sheets and I would like to write VBA codes
to loop through each sheet and write out the data in one CSV file.
eg
Sheet1
1 one
2 two
3 three
Sheet2
4 four
5 five
6 sixe
I would like my output CSV file to be:
1,one
2,two
3,three
4,four
5,five
6,sive
Thanks
Chen
I am new to VBA.
I have data on a number of sheets and I would like to write VBA codes
to loop through each sheet and write out the data in one CSV file.
eg
Sheet1
1 one
2 two
3 three
Sheet2
4 four
5 five
6 sixe
I would like my output CSV file to be:
1,one
2,two
3,three
4,four
5,five
6,sive
Thanks
Chen