Raw export from Excel

[tfaiers]

I'm not sure if that's the best heading for this question but I'll give it a shot.

We're pulling loads of data from various spreadsheets with lookups to create a group of cells that when compile will form an HTML script so we're automating the creation of our index pages.

We've just modified the site so that the HTML pages work out to be more complicated and therefore the script is bigger. Excel has a limitation on the amount you can contain in one cell so where it used to work, now the cell contents concatenated together is too big.

Is there anyway of exporting A1:Z1 continously as a text file (saved as x.html) without any formatting?

Regards
Tony

 

[bulrush]

Tony,
I think you have just discovered that when you use the wrong tool for the job, you will come across limitations. Perhaps if you used MS Access to grab the data from Excel, you might have more flexibility.

I used MS Access to make HTML pages based on the contents of a table. Access writes text files just fine.