please tell me how to connect, add, delete, update records in Excel using vb6

Hello ,

Am doing a quick project with vb6 and excel.

I want to to the following,

connect to excel
add record under a defined row and in a sheet
delete
update

when adding and updating, what happens to cells with functions or macro?

thanks

Quote:

---

Originally Posted by coolcurrent4u

when adding and updating, what happens to cells with functions or macro?

---

In case you are adding or updating data the current data will be deleted by the new data.
If the cells you are filling with new data did hold a function the same will happen as with data (i.e. current function is deleted, new function or data is inserted).
I'm not sure what is meant by cells holding a macro, in case the cell held a call for a function or sub, the same happens as above!

see the faq thread in office development forum for tutorial on automating office applications