Open Import dialog via VBA... (1 Viewer)

Hi all -

this is probably easy but I cannot find functioning code for this for the life of me..

How can I open the Import dialog box from VBA? I have a button on a form that reads "Import..." and upon clicking it i would like it to trigger the import box. This will become a function called in an automated process so please, no suggestions to click file, get external data, import...

Thanks in advance for any input on this!!

First you have to click file, get external data, import...

Then add this step to your code.

Good luck!

ghudson said:

First you have to click file, get external data, import...

Then add this step to your code.

Code:Copy to clipboard

DoCmd.RunCommand acCmdImport

Good luck!

Click to expand...

hahaha...jerk

jk - Thanks alot! thats awesome! I knew it was something simple

there isnt a way to pass in default properties for that is there? like as far as file type and the directory path to look in??

if not, no worries but would be cool to add... - THANKS AGAN!!