D
debartsa
Hi Everybody,
I'm looking for a way to accomplish the following:
I have an Excel Worksheet that gets populated with data using VBA which gets
data from an ADO 2.5 Recordset object in memory on the user's workstation.
My goal is to bind the Worksheet to the ADO Recordset i.e. as the user
updates, deletes or creates data existing on the worksheet, the ADO
Recordset gets updated accordingly.
I'm guessing that if I could capture Worksheet events such as an event
firing when a row on the Worksheet is deleted, updated, etc... I could use
this opportunity to sync the Worksheets data to ADO?
I haven't been able to find any events on the Worksheet for Row deletions,
updates or insertions, Do they exist? I'm using Excel 97.
Thanks for any help!
Sam
I'm looking for a way to accomplish the following:
I have an Excel Worksheet that gets populated with data using VBA which gets
data from an ADO 2.5 Recordset object in memory on the user's workstation.
My goal is to bind the Worksheet to the ADO Recordset i.e. as the user
updates, deletes or creates data existing on the worksheet, the ADO
Recordset gets updated accordingly.
I'm guessing that if I could capture Worksheet events such as an event
firing when a row on the Worksheet is deleted, updated, etc... I could use
this opportunity to sync the Worksheets data to ADO?
I haven't been able to find any events on the Worksheet for Row deletions,
updates or insertions, Do they exist? I'm using Excel 97.
Thanks for any help!
Sam