Macro that will bring up Import Wizard

[Marbinski]

I am trying to create a macro that will bring up the Import Wizard. Im not sure if there is a command but I tried using the command "Transfer Spreadsheet" but that didn't work. Any suggestions?

If this info helps, the spreadsheet is called (ScopingImport.xls) and has all the exact field names as the headings for the table to be imported to (TBL_ZipsImp).

 

[Hayley Baxter]

You can use the Run Command Action and Import which will bring up the dialoug box for you to locate your spreadsheet, from here the import wizard will start upon selection.

Hay

 

[Marbinski]

Thanks works...perfectly!