Open Import dialog via VBA...

[CliffHanger9]

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!!

 

[ghudson]

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

Then add this step to your code.

DoCmd.RunCommand acCmdImport

Good luck!

 

[CliffHanger9]

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

Then add this step to your code.

DoCmd.RunCommand acCmdImport

Good luck!

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!!