| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to show External Data Options form
Hi All,
I wish to show the "External Data Range properties" dialog using code. When I try this: Application.CommandBars(1).FindControl(ID:=1951, recursive:=True).Execute I get "Method 'Execute' of 'CommandBarButton_' failed". Why?? I am sure a querytable is selected when I run the code. This code: Sendkeys "%dda" DOES work, but I don't want to use sendkeys, for obvious reasons. Regards, Jan Karel Pieterse Excel TA/MVP |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show Data validation List options in a msgbox | Excel Discussion (Misc queries) | |||
| Printing Form to Include All Options in Excel | New Users to Excel | |||
| chart options show data table | Charts and Charting in Excel | |||
| Cannot save external data into file excel system show not respondi | Excel Discussion (Misc queries) | |||
| How can I export data from an Excel form into an external Excel d. | Excel Discussion (Misc queries) | |||
Threaded Mode
