Open file dialog box

[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

 

[Dev Ashish]

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.

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

 

[yann]

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

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