Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Sumproduct using ADO

  Asked By: Phil    Date: Aug 15    Category: MS Office    Views: 575
  

I want to use the function sumproduct for an external data.
If I retrieve the data using ODBC (microsoft query) the function
works fine, but if I retrieve using ADO (VBA), the sumproduct will
fail summing the data. Fyi both of the data using ODBC and ADO are
actually the same. Can somebody help me?

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Brandon Tucker     Answered On: Aug 15

How are you using SumProduct()? Can you mention a line of code?

 
Didn't find what you were looking for? Find more on Sumproduct using ADO Or get search suggestion and latest updates.




Tagged: