Select Drive, Folder then transfer spreadsheat

[Randy]

Access 2000. I need a way to select a drive, either A-Floppy or a
removeable flashdrive, then transfer an excel spreadsheet. The drives must
be selectable, because different computers have different drives for the
flashsticks. One may be f, another may be g, etc. Thanks..Randy

 

[Douglas J Steele]

Do you want to let them select the actual file, or is the file name
precoded, and they only need to indicate where the file is?

For the former, check out http://www.mvps.org/access/api/api0001.htm at "The
Access Web"

For the latter, check out http://www.mvps.org/access/api/api0002.htm

 

[Randy]

I invision a form where a filename is created and entered via txtbox. The
user selects a drive where the transfer spreadsheet is sent to, A, and
whatever the flashdrive is assigned to. I am going to transfer excel files
to either the floppy or flashdrive..

 

[Douglas J Steele]

Well, check out the 2 links I gave you: one of them will hopefully meet your
needs.

 

[Randy]

Thank you, I'll give them a try..

Well, check out the 2 links I gave you: one of them will hopefully meet
your
needs.