Cetin,

I've found another way to generate spreadsheets quickly is to design what I want my output to look like in Excel, export this to an HTML format, reverse engineer the HTML Excel is generating, and then use textmerge() to generate a fully loaded spreadsheet.

This works going back to Excel 2000. There are no limitations on the size of your export other than what Excel can normally handle. And you can markup your exported content with colors and font effects (bold, italic, etc).

So if you can figure out how you want your information structured in Excel, this may help move your raw content. If you have VBA code that needs to round trip, perhaps you could place this code in a seperate "dashboard" type spreadsheet whose purpose is to load your spreadsheet exports and manage them.

In other words, you would have a master dashboard spreadsheet with all your VBA logic, etc and a menu of files to import or even a file picker. Users would pick one of your raw HTM exports (note that you can even use a XLS extension and Excel will properly load your HTM content) and your dashboard would load the data and help the user navigate (print, annotate) the data as needed.

VFP's textmerge is so fast, perhaps your VFP app could generate hard coded HTM exports for each "cube" of data a user wanted to view?

Hope this gives you some ideas,

Malcolm