Visual Studio Development Bookmark and Share   
 index > Visual Studio Tools for Office > show connection editor
 

show connection editor

I would like to know if it possible to start Workbook connection dialog (excel build-in) from my c# code (excel plugin)?
Matej Golob  Saturday, October 17, 2009 11:44 AM
HiMatej Golob!

What version of Excel are you using?
I tested the following code in Excel 2007.
It displays the Workbook Connections dialog.



Globals.ThisAddIn.Application.CommandBars["Nil"].Controls["&Workbook Connections..."].Execute();


You might also want to take a look at Application.Dialogs although
I'm not familiar which of the enumeration values corresponds to the Workbook Connections dialog.

Jose Anton Bautista  Saturday, October 17, 2009 4:01 PM
HiMatej Golob!

What version of Excel are you using?
I tested the following code in Excel 2007.
It displays the Workbook Connections dialog.



Globals.ThisAddIn.Application.CommandBars["Nil"].Controls["&Workbook Connections..."].Execute();


You might also want to take a look at Application.Dialogs although
I'm not familiar which of the enumeration values corresponds to the Workbook Connections dialog.

Jose Anton Bautista  Saturday, October 17, 2009 4:01 PM

You can use google to search for other answers

Custom Search

More Threads

• Slide name has been changed when open a presentation on PPT 2007/Vista
• Outlook Upgrade
• Outlook freezes after creating e-mails from word doc
• Outlook 2003 Add-in
• Custom functions in Excel
• VSTO 2008 Excel 2007 Transparent Proxy Failure
• The customization cannot be installed because another version is currently installed and cannot be upgraded from this location.
• Outlook: checking Inspectors for beeing equal
• Office Add-in
• How To Remove A Menu Button in Office