shs91
10-24-2016, 10:21 AM
Hi all :)
I hope you guys can help me with this one.
I have a workbook with a number of sheets which I want to save as text files. I have tried google it, but none of the really worked.
Basically in pseudo code the code should do the following:
//
For each sheet in workbook
Save sheet as text file (name should be sheet name and same location as workbook)
Next sheet
//
Please note I have a lot of (1 million active cells per sheet) data, so the code should be efficient.
I know this seems really easy, but somehow it doesn't work for me.
Please help me.
Thanks Simon :)
I hope you guys can help me with this one.
I have a workbook with a number of sheets which I want to save as text files. I have tried google it, but none of the really worked.
Basically in pseudo code the code should do the following:
//
For each sheet in workbook
Save sheet as text file (name should be sheet name and same location as workbook)
Next sheet
//
Please note I have a lot of (1 million active cells per sheet) data, so the code should be efficient.
I know this seems really easy, but somehow it doesn't work for me.
Please help me.
Thanks Simon :)