View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
THZS THZS is offline
external usenet poster
 
Posts: 4
Default Open "xlDialogChangeLink" Dialog with VBA/VB.Net

I want to open the "ChangeLink" Dialog in my Excel 2007 project. The user of
my program should have the ability to select the datasource for a pivottable.

Application.Dialogs(Excel.XlBuiltInDialog.xlDialog OpenLinks).Show() or
Application.Dialogs(Excel.XlBuiltInDialog.xlDialog ChangeLink).Show()


raise the following exception

"The show method of the dialog object can not be executed" (translated from
German error message)