Question regarding a macro using TransferDatabase 1

[djbjr]

Hopefully I am in the right forum, I apoligize if I am not.

I created a Macro which loads a table using the TransferDatabase method and it works fine.

When I run the Macro, a DBF file is grabbed and loaded into in Access table and then an append query loads the final table.

My question is, can I set it up so it prompts the user to select the source file? I need to load this file regularly and the file name changes.

Thanks in advance.

 

[PHV]

Convert your macro to VBA and then have a look at the InputBox function or the FileDialog object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[djbjr]

Thanks so much it worked, its like I wrote VBA!

So now I just need to figure out how to make it browse for the file when the button is clicked.