Undefined function 'replace' in expression
Hi there,
I'm trying to get some data from an Access database using Excel.
Once the connection established, I run a query with the Replace function.
The problem, is that I get this error message:
"Undefined function 'replace' in expression".
I think it's a reference that I'm missing, but I don't know which one.
Those I have checked a
- Visual Basic for Applications
- Microsoft Excel 11.0 Object Library
- Microsoft ActiveX Data Objects 2.8 Library
- OLE Automation
- Microsoft Office 11 Objects Library
- Microsoft Scruotubg Runtime
- Microsoft DAO 3.6 Objects Library
I have NO reference mentioned as Missing!
If you have any suggestion or idea, I'll really appreciate your help.
Thanks in advance.
|