All right. I'll check it out.
"Br@dley" <n0mail@4u.com> wrote in message
news:%rGbe.30554$5F3.8537@news-server.bigpond.net.au...[color=blue]
> In news:6hFbe.22317$Ow2.3062@fe06.lga,
> Robert <projecttoday@yahoo.com> said:[color=green]
>> Because I'm assuming VBA is VB6 not VB.NET. But anyway I don't care
>> what it is as long as it works in Access. I am definitely using
>> Access, sorry if I gave the wrong impression.
>>
>> I tried:
>>
>> 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)
>>
>> and it told me that function ahtAddFilterItem was not found. How do
>> I find this function?[/color]
>
> Read the notes carefully...
>
> ".. see the included function TestIt() .."
>
> The function is listed on this page:
>
http://www.mvps.org/access/api/api0001.htm
>
> Br@dley
>
>
>
>
>
>[color=green]
>> "Br@dley" <n0mail@4u.com> wrote in message
>> news:NKEbe.30196$5F3.21458@news-server.bigpond.net.au...[color=darkred]
>>> In news:EEEbe.24355$Gq6.21280@fe02.lga,
>>> Robert <projecttoday@yahoo.com> said:
>>>> "Br@dley" <n0mail@4u.com> wrote in message
>>>> news:bqCbe.29583$5F3.10884@news-server.bigpond.net.au...
>>>>> In news:NPBbe.22783$Gq6.15243@fe02.lga,
>>>>> Robert <projecttoday@yahoo.com> said:
>>>>>> I'm using an unbound form to upload an Excel spreadsheet into
>>>>>> Access and I was wondering if there is a control available that
>>>>>> would allow me select the desired file name and path. I can't
>>>>>> seem to find any such control in my toolbox.
>>>>>>
>>>>>> Robert
>>>
>>>>> You'd need to all up the Windows file dialogs using Windows API
>>>>> calls. Look at
http://www.mvps.org/access/ under "APIs"
>>>
>>>> Is this in .NET? Is there a way to do this in VB 6? Anybody?
>>>
>>>
>>> No, it is in Access/VBA. That was an Access site and this is an
>>> Access forum.....
>>>
>>> You asked how to do it in Access, why now ask for VB6?
>>> --
>>> regards,
>>>
>>> Bradley
>>>
>>> A Christian Response
>>>
www.pastornet.net.au/response[/color][/color]
>
> --
> regards,
>
> Bradley
>
> A Christian Response
>
www.pastornet.net.au/response
>[/color]
