Hello There,
I would like to know how this can be achieved using VBA:
1. Clear the range table data.
2. To transfer the range table data to a ADODB recordset (excluding its 1st column). Please refer the code written for retrieve data in the workbook where ADODB recordset is used for retrieving the data and inserting it in the table.
Attached workbook for your reference.
Thanks & regards
Don
I would like to know how this can be achieved using VBA:
1. Clear the range table data.
2. To transfer the range table data to a ADODB recordset (excluding its 1st column). Please refer the code written for retrieve data in the workbook where ADODB recordset is used for retrieving the data and inserting it in the table.
Attached workbook for your reference.
Thanks & regards
Don