Need MS Excel macro to convert multiple sheets of an excel file to single txt file

We have a excel .xls data file having numerous sheets each containing maximum number of rows (65000). We want to generate a separate text or csv file to include data present in all the sheets together. The data in each sheet is of identical format. Could anyone help with a suitable macro code which can generate such file.

Hi..

That's potentially a LOT of values getting written to the text file..

How many columns in each sheet and how many sheets?

The reason i ask is I tried for an array based solution.. but.. the time it will take to execute will depend on how many columns your sheets contain and how many sheets..

You could try this.. it just might take a while depending on your answer to my questions above.. change the range used to suit..

Please Login or Register  to view this content.