Select drive, then Transfer rspreadsheet?

R

Randy

Access 2000. I have an unbound form with, a textbox to enter the file name,
and two texboxes to enter the beginning and ending date. I also have a cmd
button which runs a macro to transfer spreadsheet to the "F" drive. This
is fine if the drive is always "F", sometimes it may be "A: the floppy drive
or a thumbdrive which may vary by computor. Is there a way that when I
click on the comand button, I must first select which drive I want to
transfer the files? Thanks Randy
 
G

Guest

A better way would be to use a Common Dialog box and the user can browse for
the drive, folder, and file name. For this you can use the activex control,
or you can download code that will use an API to do this for you.
Unfortunately, I can't remember where I got it. I do know it was written by
Ken Getz.
 
R

RuralGuy

A better way would be to use a Common Dialog box and the user can
browse for the drive, folder, and file name. For this you can use the
activex control, or you can download code that will use an API to do
this for you. Unfortunately, I can't remember where I got it. I do
know it was written by Ken Getz.
Click to expand...

You've got to be kidding Klatuu! Our favorite web site.

http://www.mvps.org/access/api/api0001.htm
API: Call the standard Windows File Open/Save dialog box

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select Drive, Folder then transfer spreadsheat 4
Select drive to export file to 1
Automatically create excell filename via form 1
Transfer spreadsheet to flash drive 3
Selecting Drive to export/import data 14
Access My Dell PC can't access floppy drive 7
Upgrade Hard Drive - transfer data & partitions 21
HP SSD M700 Solid State Drive 0

Top