I am writing an application to import a series of Excel spreadsheets into Access (2003) and need some file access functions. I found the following which works fine.

Declare Function adh_accOfficeGetFileName Lib "msaccess.exe" _
 Alias "#56" (gfni As adh_accOfficeGetFileNameInfo, ByVal fOpen As Integer) As Long

In the same place I found the following, which doesn't work:

Declare Sub adh_accSplitPath Lib "msaccess.exe" Alias "#59" _
 (ByVal strPath As String, ByVal strDrive As String, _
 ByVal strDir As String, ByVal strFName As String, ByVal strExt As String)

(I have omitted the rest of the code to keep it simple)

When I execute the adh_accSplitPath subroutine it complains that it can't find entry point #59. The code was intended for Access 97 and I am using Access 2003, so I assume the library has changed.

Where can I find a list of these functions for Access 2003?

Does anyone know the alias for this function in Access 2003?

Is there a more portable way of doing it?

Thanks

Charlie