Open file dialog box

  • Thread starter Thread starter Susan
  • Start date Start date
S

Susan

I am using the DoCmd.TransferSpreadsheet to transfer a
excel table with a specific range, I would like not to
include a specific file name, so instead it opens the
Open file dialog box, so the user can choice the file,
but at the same time I do not want to eliminate the
import range I have set, what are my options.

Thank you
Susan
 
I am using the DoCmd.TransferSpreadsheet to transfer a
excel table with a specific range, I would like not to
include a specific file name, so instead it opens the
Open file dialog box, so the user can choice the file,
but at the same time I do not want to eliminate the
import range I have set, what are my options.
Click to expand...

Call FileOpenDialog before calling TransferSpreadsheet and pass the
filename provided by the user as the option.

[ http://www.mvps.org/access/api/api0001.htm ]

-- Dev
 
Hi Dev,

is the FileOpenDialog usable only in .NET

I am getting a compile error when using it in Access 200
Please kindly advise how FileOpenDialog can be use in Access

Thanks in advanc
yan

----- Dev Ashish wrote: ----

I am using the DoCmd.TransferSpreadsheet to transfer a
excel table with a specific range, I would like not to
include a specific file name, so instead it opens the
Open file dialog box, so the user can choice the file,
but at the same time I do not want to eliminate the
import range I have set, what are my options
Click to expand...

Call FileOpenDialog before calling TransferSpreadsheet and pass the
filename provided by the user as the option

[ http://www.mvps.org/access/api/api0001.htm

-- De
 
Back
Top