General information
Category:
Object Oriented Programming
Title:
Very Slow creation of Excel Object
I have been trying to send data to an Excel Object as follows and it takes about 2 minutes per 100 records. Is there anything I can do to speed it up
n= 0
SCAN
n = n+1
oExcel.Cells(1,n) = FirstName
oExcel.Cells(2,n) = LastName
oExcel.Cells(3,n) = Address1
oExcel.Cells(4,n) = Address2
ENDSCAn
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