General information
Category:
COM/DCOM and OLE Automation
Title:
Excel pagesetup properties very slow
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only