Connect Excel FUNCTION (VBA) to the Access Database...

[a4623873]

Dear friends,
I have an Excel workbook and an Access DataBase which contains data:
DATE | DATA1 | DATA2 | DATA3

I need to write a function like this:
MYFUNCTION( CR1, CR2)

Is it possible MYFUNCTION to get data from the Database?

 

[Jon von der Heyden]

What is CR1 and CR2? What results does it produce?

If it's part of a query you can use the function in your Access SQL query, and then execute the query from Excel. But for now I'm still not totally sure what you are trying to do, or what role DATE|DATA1|DATA2|DATA3 has.

 

[a4623873]

What is CR1 and CR2? What results does it produce?

If it's part of a query you can use the function in your Access SQL query, and then execute the query from Excel. But for now I'm still not totally sure what you are trying to do, or what role DATE|DATA1|DATA2|DATA3 has.

Thanks for your answer,
CR1 and CR2 are criterias that the function gets from the excel cells.
The Database should only contain datas, and the function should get the datas from DB using the CR2 criteria, and do some calculation then return the result in it's cell.
I have written the code for the function, but can't make it read/get data from the database.

 

[Jon von der Heyden]

It sounds to me like you should be setting up a parameter query rather than the function. Set-up the PQ in Access and then execute it from Excel, feeding in the parameters from the values housed in your Excel workbook.

See tutorial here.