Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Lotus 1-2-3 97 Constants...Arrgghh!
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00582803
Message ID:
00582838
Views:
27
Hi Evan,
>
>I might be oversimplifying this...
>but who says you have to "re-populate" the same sheet?
>
>Since you're automating this *anyway* (g), I'd consider just dumping the first worksheet, reloading the template, populating it with the new data, and printing again. Yeah, it's a kludge, but it would sure save the Excedrin...

This is the last resort, mainly because it will take more work. Both of the objects (one for Excel, one for 1-2-3) are actually children of a parent class that serves to abstract the interface (as well as doing the calculations and data manipulation) that produce the sheet. What this would entail is moving one call to the class's OpenFile() method into several different methods, plus closing the file. Not only would this increase the code base, but hurt performance as well.

>BTW, I agree about the Lotus products. I'm forced to use Notes most days at one particular location -- what a PITA.
>
I've got to use it daily.:-( PITA to me simply isn't a strong enough description.< g >
George

Ubi caritas et amor, deus ibi est
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform