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...
>As anyone who has been here for any reasonable length of time may know, my loathing for Lotus products knows no bound. To-day provided another instance of one of the reasons for this. Let's cut to the chase.
>
>I'm trying to populate a 1-2-3 spreadsheet with data, clear it, re-populate it and print again. No problems with populating or clearing or printing it the first time. The second time, however, it appears that only one of the cells is being printed.
>
>In order to try and fix this, I delved into what passes for the help file. There I found a property (PrintSettings) and a constant ($CurrentSheet) to set it to, that I hope will fix this. The problem is twofold. First, no where (including the type library and the Lotus web site) does it say what object the PrintSettings property belongs to. Second, similarly and even more frustrating, the value of the constant cannot be located either.
>
>Note that all works fine with Excel and was easy to implement.
>
>Anybody got any info on this?
Mark McCasland
Midlothian, TX USA