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?
"Br@dley" <n0****@4u.com> wrote in message
news:NK*******************@news-server.bigpond.net.au...
In news:EE*******************@fe02.lga,
Robert <pr**********@yahoo.com> said: "Br@dley" <n0****@4u.com> wrote in message
news:bq*******************@news-server.bigpond.net.au... In news:NP*******************@fe02.lga,
Robert <pr**********@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
