Excell: VBA Function that Calls SQL Query

M

Mike

Hi everyone,

I have a VBA function like this:

Function Total(VarName1, VarTable, VarName2, VarValue1, VarName3, VarValue2)

Inside the function, I have a query of the type:
Total = "Select VarName1 From VarTable Where VarName2 = 'VarValue1' AND VarName3 = 'VarValue2' "

The function will be used as Add-ins in Excel. Note the words that start with "Var..". In a cell, I would type: "=Total(..,..,..,..,..,..)"

My question: How should I define Var.. ones in "Function Total(...)" and "Total = " so those values are typed inside the excel cell, and then scrolled down?

Thanks,
Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

To SQL Expert: VBA Function that Calls SQL Query 3
writing a value to a particular cell from function 3
Simple Module for Excel 2007 in VBA 6
user defined function which increase consecutively while passingbelow cells 12
VBA Question 7
VBA - function doesn't calculate unless clicked on 2
ODBC-Query with a parameter (by function) 0
Tool for building user-defined functions without knowing VBA: usef 2

Top