Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automation from VB6
I've got a VB 6 project where I am populating a spreadsheet with data from
an ADO recordset and I've got a couple of questions. First, is anyone aware of a way to populate the spreadsheet quickly? Right now, I'm cycling through every record and field of the recordset, reading the value from the recoordset, and then pasting the value into the the corresponding spreadsheet cell. Seems to be very slow! Second, is there any way to check to see if the user has manually closed the Excel session before I attempt to close it in code? Thanks for any help. Bob |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automation from VB6
Bob,
The CopyFromRecordset method copies the RS to a worksheet range. -- HTH RP (remove nothere from the email address if mailing direct) "Robert A. Boudra" wrote in message ... I've got a VB 6 project where I am populating a spreadsheet with data from an ADO recordset and I've got a couple of questions. First, is anyone aware of a way to populate the spreadsheet quickly? Right now, I'm cycling through every record and field of the recordset, reading the value from the recoordset, and then pasting the value into the the corresponding spreadsheet cell. Seems to be very slow! Second, is there any way to check to see if the user has manually closed the Excel session before I attempt to close it in code? Thanks for any help. Bob |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automation from VB6
Thanks! That works great!
Bob "Bob Phillips" wrote in message ... Bob, The CopyFromRecordset method copies the RS to a worksheet range. -- HTH RP (remove nothere from the email address if mailing direct) "Robert A. Boudra" wrote in message ... I've got a VB 6 project where I am populating a spreadsheet with data from an ADO recordset and I've got a couple of questions. First, is anyone aware of a way to populate the spreadsheet quickly? Right now, I'm cycling through every record and field of the recordset, reading the value from the recoordset, and then pasting the value into the the corresponding spreadsheet cell. Seems to be very slow! Second, is there any way to check to see if the user has manually closed the Excel session before I attempt to close it in code? Thanks for any help. Bob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automation?? | Excel Discussion (Misc queries) | |||
MFC Automation | Excel Programming | |||
about OLE automation | Excel Programming | |||
Automation | Excel Programming | |||
Automation | Excel Programming |