>>>Can't you just do all this in Excel, then do a Save [Excel file] then a SaveAs a Lotus file [different file extension]? What the user don't know...
>>
>>The problem is that not all users have Excel. The object first looks for it and, if found, uses it. If it's not found, then it checks for 1-2-3.
>>
>>The file itself is a template that's simply used for printing and isn't saved to a disk. Theoretcally, there can be as few as 1 page or as many as 16.
>>
>>Thanks for the suggestion, though.
>
>George,
>
>You could set up an Excel server. An unmanned station, with a VFP app running, watching for requests (perhaps in a network directory). Create the spreadsheet at that station (and save as 1-2-3 if necessary).
This is an in-proc COM server that's being called from PowerBuilder that's calling Lotus in turn. The file is a template that's used over and over again and not saved. Since few users have Excel, I'm forced to come up with a solution in 1-2-3.
Thanks for the suggestion, however.
George
Ubi caritas et amor, deus ibi est