| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
ODBC Link to db with custom modules
Hi All,
I've created an Access 97 database which performs some nice functions that have been created using Modules. When I'm in Excel and create an Pivot table using an external source (then connect to the QUERY in my database) it gives me an error message saying "Undefined function 'ConvertDate' in expression". 'ConvertDate' is the function that my module creates in my Access Database. Does anyone know if its possible to connect to my database?? I still need the function to be working in Access, is there anyway I can define it in excel so its happy and pulls it in? -- Adam ----------- Windows 98 + Office Pro 97 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
| Past Link then copy | Excel Discussion (Misc queries) | |||
| How to Link named ranges from multiple Workbooks into a single Wo. | Excel Discussion (Misc queries) | |||
| How do link to a remote worksheet using the path value in a field? | Links and Linking in Excel | |||
| How do link to a remote field but use the path from a stored field | Excel Discussion (Misc queries) | |||
Linear Mode
