| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import External Data Wizard
I am trying to initiate the Import External Data Wizard using code. I'm using
Excel 2003. I've tried using the following code: Dim ImportData As CommandBarButton Set ImportData = CommandBars("Worksheet Menu Bar") _ .Controls("Data").Controls("Import External Data").Controls("Import &Data...") ImportData.Execute The above code results in the following error. 2147467259 - Execute Failed I also tried to use Application.Dialogs, but I was not able to find the right dialog. How can I accomplish this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 data import wizard does not support line ends in fields | Excel Discussion (Misc queries) | |||
| How to Start Excel in Text Import Wizard for data import | Setting up and Configuration of Excel | |||
| while opening a Office file i am getting Data import wizard | Excel Worksheet Functions | |||
| excel import external data wizard | Excel Discussion (Misc queries) | |||
| Get External Data - not editable using Query Wizard | Excel Discussion (Misc queries) | |||
Threaded Mode
