James Gray
2/3/2005 2:36:00 PM
Graham Foster wrote ..
> Hello,
>> I think you should give it a shot.
> So I did. Its awfully VBish in its style.
>
> I took the approach that it was a waste of time to migrate the
> subtotals, as spreadsheets do this anyway, and they would be
> automatically recalculated as the data were updated / corrected. I've
> got a bug that I can't see, in that spurious short lines are output
> periodically.. (Its probably obvious - but its late...)
>
> The missing bit (a quick macro to open the output file and run
> sub-totals is simply a modified recorded macro in Excel). I haven't
> figured how to do this programmatically in StarOffice yet - (Which is
> what I use)
>
> It was enjoyable getting this far.. I'll look further at other quizes
> too.
>
> --
> Best regards,
> Graham