Transfer spreadsheet to flash drive

[Guest]

MS Access 2000. Is there a waty to transfer an excel file (Transfer
spreadsheet) to a selectable drive? I want to send excell files to a flash
drive or a floppy drive, I need to chose the drive. Thanks, Randy.

 

[KARL DEWEY]

Not an Access question but open Excel file and select Save As, then select
your drive, and save.

 

[Guest]

It is an access question. What i have now is a macro that exports a report
through transferspreadsheet, converts it to an excel file and sends it to
the A; floppy drive. I want to be able to select the drive before
transferring the file.

 

[KARL DEWEY]

Did not read it throughly.
Probably will need VBA in a module so as to use a variable.