Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calling MVP's & pro's urgently please !!
Dear All,
I've had an unanswered post below and I really need some help on this asap. I have a project I need to complete cob today! -------------- 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 |