>I'm working to output a VFP report to an Excel .xlsx file. It will have a very different structure from the VFP report so I can't use any sort of direct output-to-Excel function. ...
>I could suggest another approach. The data is loaded first into a temporary sheet (I use a query from SQL-server). The final layout is created with a VBA macro.
Thanks. Clearly, people have thought of some interesting approaches to generate Excel output.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up