listDir and listdrive controls in Access 2000

  • Thread starter Thread starter stevens
  • Start date Start date
S

stevens

In VB 6.0, there are two controls called listDir and listDrive. They are
the common listing of directories and drives we all use every day. I have a
form in Access 2000 in which I am using the TransferSpreadsheet method to
move some data from an Excel SS to an Access table. The problem is that the
TransferSpreadsheet requires the actual name of the XLS file to transfer
from. What I want to do is on the Access form command button, have it bring
up a browse dialog box so the user can navigate to the file and select it,
having it populate a variable that can be used in the filename of the
TransferSpreadsheet method. Can anyone think of a way to do this? Is there
a better way? Thanks
 
In VB 6.0, there are two controls called listDir and listDrive. They are
the common listing of directories and drives we all use every day. I have a
form in Access 2000 in which I am using the TransferSpreadsheet method to
move some data from an Excel SS to an Access table. The problem is that the
TransferSpreadsheet requires the actual name of the XLS file to transfer
from. What I want to do is on the Access form command button, have it bring
up a browse dialog box so the user can navigate to the file and select it,
having it populate a variable that can be used in the filename of the
TransferSpreadsheet method. Can anyone think of a way to do this? Is there
a better way? Thanks
Click to expand...

Yes. See http://www.mvps.org/access/api/api0001.htm.
 
Back
Top