Using External data wizard in code

[sthapa]

Hi all

I just to know what the command or code is to generate the External data wizard is ?
I want to import a spreadsheet, the thing this there will be a new spreadsheet everyday with a different name. I guess the easiest way is for the user to select the file themselves. instead of the user going to file, get external data, i thought i could add the code to invoke this wizard on a button.

Thanks in advance

 

[Pat Hartman]

If you search here or the kb you will find articles that give you the code for using the API to the common dialog. It is better to use the API. That way you don't have to have the license for the activeX installed on your machine and the users machine. The license does NOT come with Access. You need VB6 or the Access developer's edition.