Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run Query w/Function from Excel
Has anyone run into this before?
I have query in Access with a function that I wrote as one of the fields. My problem is that when I try to run the query from Excel using ADODB.Command I get the following error: "Run-time error '-2147217900(80040e14)': Undefined function 'Function Name' in expression.." This query is a parameter query so, I need to be able to pass the parameters to the query. Thanks in advance, Kev |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run Query w/Function from Excel
Load the reference for ADO in Visual Basic.
Under Tools/References load the latest "Microsoft Activex Data Objects X.X Library" where X.X is the latest version you have, i.e. 2.7. This is on the VBA Macro side of your spreadsheet. -----Original Message----- Has anyone run into this before? I have query in Access with a function that I wrote as one of the fields. My problem is that when I try to run the query from Excel using ADODB.Command I get the following error: "Run-time error '-2147217900(80040e14)': Undefined function 'Function Name' in expression.." This query is a parameter query so, I need to be able to pass the parameters to the query. Thanks in advance, Kev . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SQL Query - To Excel - My Workbook Does not Function Properly | Excel Discussion (Misc queries) | |||
Query SQL Data in Excel with a function? | Excel Worksheet Functions | |||
SQL & Like Query function in excel | Excel Worksheet Functions | |||
Microsoft Query rejects "nz" function in Access Query | Excel Discussion (Misc queries) | |||
Excel Web Query Function | Excel Programming |