Save each sheet as a text file

[shs91]

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

[Neil_]

Please Login or Register  to view this content.

[YasserKhalil]

Cross post at this link
http://www.vbaexpress.com/forum/show...as-a-text-file