ADO

[jayjay60]

I would like to use ADO to keep database record in excel sheet. But I don't know how to do that. And the second step of my problem is of being able to compare value in the database to one given in a dialog box. In fact I'm building an automation which need to catch good value into a database according to a parameter given in my dialog box.

So if anybody could help me....

thanks

gerald

 

[Cagliostro]

My advice is not to use DAO/ADO/ODBC for working with excel. The best way is to work with Excel.Application COM objects. John Fill

ivfmd@mail.md

 

[jayjay60]

OK, but is it not more difficult to do? In fact I need to create a dialog box automation where the user give a date which will be compared to a database of COleDateTime, so if I could find the same I need to keep an interest rate which correspond to this date.
I know that I could use excel.application COM objects to open workbooks..., but I don't know how to read and find the value I need.

thanks for your help

Gerald

 

[Cagliostro]

See into OLE/COM object viewer the excels interface IDispatch. John Fill

ivfmd@mail.md