Prompt user for drive letter

[Rodney24]

Currently I am using a macro to copy my primary tables to a specific drive
letter (USB flash drive) but if another USB device is plugged in while the
laptop it renumbers the drive letter. Is there a way to prompt the user to
select the correct drive letter?

 

[Steve Schapel]

Rodney,

Yes it is. For example, you can put an unbound textbox on the form from
which the macro is called, where the user can type in the drive letter of
the USB drive, and then refer to this textbox in the macro arguments.

 

[Douglas J. Steele]

Randy's site is http://vbnet.mvps.org