Prompt user for drive letter

  • Thread starter Thread starter Rodney24
  • Start date Start date
R

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?
 
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.
 
Back
Top