Importing API Call

[Michael Johnson]

I am trying to use this code to allow the user to select
an excel file import, but everytime I try to use it it
gives me a error (Object or Variable Not Defined) Any help
is great.

Dim strFilter As String
Dim strInputFileName as string

strFilter = ahtAddFilterItem(strFilter, "Excel Files
(*.XLS)", "*.XLS")
strInputFileName = ahtCommonFileOpenSave( _
Filter:=strFilter, OpenFile:=True, _
DialogTitle:="Please select an input
file...", _
Flags:=ahtOFN_HIDEREADONLY)

 

[Douglas J. Steele]

That snippet looks as though it's from
http://www.mvps.org/access/api/api0001.htm at "The Access Web".

Have you copied all of the code that's in the shaded section into a new
module? What did you name the module when you saved it?

 

[Cheryl Fischer]

The only thing that comes to mind is to ask if you have all of the
supporting code (found at: http://www.mvps.org/access/api/api0001.htm )
copied to a Public Module.