Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel pagesetup properties very slow
Message
From
10/11/2000 09:48:21
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Excel pagesetup properties very slow
Miscellaneous
Thread ID:
00440163
Message ID:
00440163
Views:
71
Hi,

We are using excel to print from VFP. I found that setting properties of the pagestup object is very slow (taking up to a few seconds, so setting 10 properties can take about 1 minute). code is like:
with oxl.activesheet.pagesetup
.centerheader="some text"
.leftheader="more text"
etc. etc.
end with

Is there a way to speed this up?

Thanks,

Auke
Next
Reply
Map
View

Click here to load this message in the networking platform