how to implement "in-Ribbon" Gallery ?

Visual Studio Tools for Office

Windows Tech ‹ Office
- Archive
  - Windows Vista
  - VS 2008
  - VB
  - Visual Studio
  - IE
  - Smart Device
  - Windows Forms
  - Dotnet
  - Game
  - Windows Live
  - Visual C#
  - Office
  - VFP
  - Architecture
  - ISV
  - SQL Server
  - VC++
  - VS Express
  - SharePoint

- Previous
  - 1
    - Form opening up a word.dot VSTO Well, if you think it through, the logic that's bothering you would actually result in an endless loop, as each new document would fire the Startup, etc. Until you ran out of memory. However, the assembly instance is the same for all the documents, so it loads only the one time. After that, it has already started, so won't start again. Tag: Visual Studio Tools for Office how to implement "in-Ribbon" Gallery ? Office
  - 2
    - Save a word document I am opening a word document as follows Case "doc" objWord = CreateObject( "Word.Application" ) objDoc = objWord.Documents.Open(OFD1.FileName ) objDoc.Select() rtbText.Text = objWord.Selection.Text objDoc.Close() objWord.Quit() My question is, how after the document has been changed, can I save it as a word document keeping all its formating Tag: Visual Studio Tools for Office how to implement "in-Ribbon" Gallery ? Office
  - 3
    - Form Region display issue Form regions are designed to scale automatically. This means that they should always be designed on a machine with the screen resolution set to 96 dpi. I'd guess that your screen resolution when you designed the regions was set to something else. Tag: Visual Studio Tools for Office how to implement "in-Ribbon" Gallery ? Office
  - 4
    - OutlookSpy and Control ID's Morning all, I want to use Outlookspy to produce a complete list of control id'd for Outlook 2003 and Outlook 2007. I have not got a clue how to do this, could any of you good natured techies please tell me how to go about doing this. Please send me intructions by email as well as posting to pat.kitchener@conwy.gov.uk Many thanks in anticipation opf your help Pat Tag: Visual Studio Tools for Office how to implement "in-Ribbon" Gallery ? Office
  - 5
    - Visual Studio Tools for Office VSTO Word Is anyone out there have come across adding more than one word document to a visual studio solution. It is possible to add a new item or an existing item and add a word document. However Visual Studio does not create the code behind the document like ThisDocument.cs and the designer.xml and designer.cs files. Any idea Tag: Visual Studio Tools for Office how to implement "in-Ribbon" Gallery ? Office
  - 6
    - Registry entries for all users (Outlook add-in) No, that's not possible. Tag: Visual Studio Tools for Office how to implement "in-Ribbon" Gallery ? Office
  - 7
    - Method to refresh/update Word toolbar state I found a workaround! Code Snippet if(commandBar.Visible == true) { commandBar.Visible = false; commandBar.Visible = true; } Thanks, Guy Tag: Visual Studio Tools for Office how to implement "in-Ribbon" Gallery ? Office
  - 8
    - How to Add custom information in an appointment item using VSTO SE Outlook 2003 Addin ? Hi, I am creating a VSTO SE Addin for Outlook 2003 and i want to store some custom information in the form of Key-Value pair in every appointment item i have. Can anybody tell me is this possible to achieve this Thanks in advance. Tag: Visual Studio Tools for Office how to implement "in-Ribbon" Gallery ? Office
  - 9
    - Copying RTF into word and from word to a richtext box using c# Hi Steve Better to post a new question, with a link to any relevant, existing discussion. If you post to a message thread already marked as "Answered", there's a good chance no one will see it... You're more likely to get a discussion on your question, with possible recommendations for (third-party) transforms in the newsgroup interface. Technically, the office.xml newsgroup would be appropriate, and you should try there. But as that gets relatively little traffic, asking in one of the general office.developer newsgroups (see " Please Read First " at the top of this forum) would be a good idea, as well. Tag: Visual Studio Tools for Office how to implement "in-Ribbon" Gallery ? Office
  - 10
    - connecting excel file to C++ program Hi every body I am a new programmer and I have been studying C++ for one semester. I know how to link and use files with these extinsions (.dat , . txt). However, I need to know how to connect excel spreadsheet with my C++ program "win 32 console application" and then I need to read my input from this spreadsheet and produce my output on it. I searched a lot but I did not find any thing. Actually, I do not know what is the solution for my problem, is it a code or a tool or something else If there is any one who can help me, I will be thankful. Moreover, If there is a refrence or a book that helps me ,please tell me and I will be glad to study it. I use MS Office 2003, Visual Studio 2005. Sorry if my question seems silly, but I really want to learn it and it is urgent. Thank you a lot . Tag: Visual Studio Tools for Office how to implement "in-Ribbon" Gallery ? Office
  - 11
    - Which "Event Handler-adding" code is more appropriate for my application add-in? I've been puzzled by something for a while...every time I go looking for good source to double-check that the CommandBar and buttons I'm adding to one of the Office apps, I seem to come across one or more variants of the two main approaches here. Approach 1 (VB): Private WithEvents uiButton As Microsoft.Office.Core.CommandBarButton Approach 2 (C#): uiButton.Click += new Microsoft.Office.Core._CommandBarButtonEvents_ClickEventHandler(uiButton_Click); I can't tell if one of these is for application add-ins and the other for document-level add-ins, or if one is VSTO 2005 and the other is new to VSTO 2005 SE, or if one is for VSTO add-ins and the other for "Shared" Add-ins> Or something else. Q: Are these types of Event Handler adding-code entirely equivalent, or are there unique dependencies, constraints or pre-requisites for using one over another Q: When should I use one vs. the other (or can I interchange them) I have a current CommandBarButton that no longer works, and I have no idea why. At some point it was working in this app's code (probably previous to this version): http://www.codeplex.com/word2mediawikipp/SourceControl/FileView.aspx itemId=130408&changeSetId=13025 Now, it no longer fires - even despite the fact that (assuming Visual Studio isn't lying to me and this Solution hasn't magically converted from VSTO for Word to a Shared Add-in) I could swear I have all the right pieces in place (at least according to these forum archives). However, for whatever reason Visual Studio won't break on the Event, and it doesn't even trap a breakpoint that I've set on all pieces of the subroutine in which the developer has involved the buttons: Public Class ThisAddIn Private W2MWPPBar As Office.CommandBar Private WithEvents uiConvert As Office.CommandBarButton Structure CommandBarButtonSettings Friend BeginGroupProperty As Boolean Friend ButtonVariable As Office.CommandBarButton Friend CaptionProperty As String Friend DescriptionTextProperty As String Friend FaceIDProperty As Integer Friend StyleProperty As Office.MsoButtonStyle Friend Tag As String Friend TooltipTextProperty As String End Structure Private Sub ThisAddIn_Startup( ByVal sender As Object , ByVal e As System.EventArgs) Handles Me .Startup Dim _Template As Word.Template For Each _Template In Me .Application.Templates If _Template.Name = "W2MWPPTemplate.dot" Then Me .Application.CustomizationContext = _Template End If If Me .Application.CustomizationContext Is Nothing Then _Template = Me .Application.AddIns.Add( "W2MWPPTemplate.dot" ) Me .Application.CustomizationContext = _Template End If Next AddCommandBar( True ) AddCommandBarButtons( True ) W2MWPPBar.Visible = True End Sub Private Sub AddCommandBar( ByVal replaceExisting As Boolean ) Dim _CommandBarsCollection As Office.CommandBars = DirectCast (Application.CommandBars, Office.CommandBars) Try If replaceExisting = True Then W2MWPPBar = _CommandBarsCollection.FindControl(Tag:=TOOLBAR_NAME) If W2MWPPBar IsNot Nothing Then W2MWPPBar.Delete() End If End If If _CommandBarsCollection.FindControl(Tag:=TOOLBAR_NAME) Is Nothing Then W2MWPPBar = _CommandBarsCollection.Add(TOOLBAR_NAME, _ Office.MsoBarPosition.msoBarTop, _ False , _ False ) Else W2MWPPBar = Application.CommandBars(TOOLBAR_NAME) End If Catch ex As System.ArgumentException MessageBox.Show( String .Format( "{0} add-in's toolbar could not be found - you won't be able to upload to the Wiki until you restart Word and/or reinstall the Add-in." , TOOLBAR_NAME) _ + vbCrLf + vbCrLf + String .Format( "Error: {0}" , ex.Message), _ TOOLBAR_NAME, _ MessageBoxButtons.OK, _ MessageBoxIcon.Error) Exit Sub End Try End Sub Private Sub AddCommandBarButtons( ByVal replaceExistingButtons As Boolean ) Dim buttonSettings As New CommandBarButtonSettings() Dim buttonsList As New ArrayList() buttonSettings.ButtonVariable = uiConvert buttonSettings.CaptionProperty = "Convert to Wiki" buttonSettings.DescriptionTextProperty = "Converts Word Documents to MediaWiki format." buttonSettings.FaceIDProperty = 2144 buttonSettings.StyleProperty = Office.MsoButtonStyle.msoButtonIconAndCaption buttonSettings.Tag = "W2MWPP Convert" buttonSettings.TooltipTextProperty = "Word2MediaWiki++ - Convert to MediaWiki syntax and upload formatted text" buttonsList.Add(buttonSettings) buttonSettings.ButtonVariable = uiUpload buttonSettings.CaptionProperty = "Upload Images" buttonSettings.DescriptionTextProperty = String .Empty buttonSettings.FaceIDProperty = 38 buttonSettings.StyleProperty = Office.MsoButtonStyle.msoButtonIconAndCaption buttonSettings.Tag = "W2MWPP Upload" buttonSettings.TooltipTextProperty = "Word2MediaWiki++ - Upload Images to wiki" buttonsList.Add(buttonSettings) buttonSettings.ButtonVariable = uiConfig buttonSettings.CaptionProperty = "Configure Word2MediaWiki++" buttonSettings.DescriptionTextProperty = String .Empty buttonSettings.FaceIDProperty = 277 buttonSettings.StyleProperty = Office.MsoButtonStyle.msoButtonIconAndCaption buttonSettings.Tag = "W2MWPP Config" buttonSettings.TooltipTextProperty = "Word2MediaWiki++ - Add-in Configuration" buttonsList.Add(buttonSettings) If replaceExistingButtons = True Then For Each _buttonSettings As CommandBarButtonSettings In buttonsList _buttonSettings.ButtonVariable = W2MWPPBar.FindControl(Tag:=_buttonSettings.Tag) If _buttonSettings.ButtonVariable IsNot Nothing Then _buttonSettings.ButtonVariable.Delete() End If Next End If For Each _ButtonSettings As CommandBarButtonSettings In buttonsList If W2MWPPBar.FindControl(Tag:=_ButtonSettings.Tag) Is Nothing Then buttonSettings.ButtonVariable = CType (W2MWPPBar.Controls.Add(1), _ Office.CommandBarButton) Else buttonSettings.ButtonVariable = W2MWPPBar.FindControl(Tag:=_ButtonSettings.Tag) End If Try With buttonSettings.ButtonVariable .Caption = _ButtonSettings.CaptionProperty .DescriptionText = _ButtonSettings.DescriptionTextProperty If .FaceId < 2 Then .FaceId = _ButtonSettings.FaceIDProperty End If .Style = _ButtonSettings.StyleProperty .Tag = _ButtonSettings.Tag .TooltipText = _ButtonSettings.TooltipTextProperty End With Catch ex As System.Runtime.InteropServices.COMException If ex.ErrorCode = -2147467259 Then MessageBox.Show( String .Format( "The {0} toolbar has misconfigured one of its buttons. Please restart Word, and if this error recurs, please file a bug at {1}." , TOOLBAR_NAME, CODEPLEX_SITE) _ + vbCrLf + vbCrLf + String .Format( "Error: {0}" , ex.Message), _ TOOLBAR_NAME, _ MessageBoxButtons.OK, _ MessageBoxIcon.Error) End If End Try Next End Sub Q: Any ideas, anyone And rumours, inferred details or pointers to good docs that you know of would be most appreciated. Cheers, Tag: Visual Studio Tools for Office how to implement "in-Ribbon" Gallery ? Office
  - 12
    - COM Exception Error Hello, I solved it. I read the deployment article that was recently posted and I didn't have the Primary Interop assemblies loaded, so I went to http://www.microsoft.com/downloads/details.aspx familyid=3c9a983a-ac14-4125-8ba0-d36d67e0f4ad&displaylang=en and ran this. Thanks, Steve Tag: Visual Studio Tools for Office how to implement "in-Ribbon" Gallery ? Office
  - 13
    - VSTO SE 2005 Runtime Setup for Windows VIsta HI, I want to install VSTO SE 2005 Runtime Setup for Windows VIsta. But on its download page, Windows vista is not listed in the supported OS. Is there a seperate runtime for Windows Vista Regards Kulvinder Singh Tag: Visual Studio Tools for Office how to implement "in-Ribbon" Gallery ? Office
  - 14
    - Publish deployment issue I'm getting an error message intermittantly when publishing my application Could not load file or assembly ..., Version=1.1.2692.18376, Culture=neutral, PublicKeyToken=...' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) Fusion Log Data: Successful load- LOG: Assembly Name is: , Version=1.1.2692.18376, Culture=neutral, PublicKeyToken=205848d03db232df LOG: Binding succeeds. Returns assembly from C:\Documents and Settings\Admin\Local Settings\Application Data\assembly\dl3\3MDEK0QZ.57D\D1GG5QL9.GKL\67c4e139\00df0250_c797c701\.dll. LOG: Assembly is loaded in default load context. Unsuccessful load attempt: LOG: Assembly Name is: , Version=1.1.2690.28864, Culture=neutral, PublicKeyToken=205848d03db232df WRN: Comparing the assembly name resulted in the mismatch: Revision Number ERR: The assembly reference did not match the assembly definition found. ERR: Setup failed with hr = 0x80131040. ERR: Failed to complete setup of assembly (hr = 0x80131040). Probing terminated. I havn't been able to isolate under what conditions it happens and what conditions it doesn't, but I am attempting to do so. My thoughts are that it may be to do with potentially having recompiled the referenced project separately, yet when the publish function is run, it recompiles the project to be published but doesn't include the latest assembly for the referenced project. Not certain tho. Would greatly appreciate any input/insight into how to resolve the issue. Tag: Visual Studio Tools for Office how to implement "in-Ribbon" Gallery ? Office
  - 15
    - Cache data in workbook created from addin How much data can you store in a custom document property Tag: Visual Studio Tools for Office how to implement "in-Ribbon" Gallery ? Office
  - 16
    - A question about office clipboard Hi, Geoff Darst, Thank you very much. Your answer is very helpful. Tag: Visual Studio Tools for Office how to implement "in-Ribbon" Gallery ? Office
- Next
  - 1
    - Excel Edit Delete Disabled Hi Nikhil... Unfortunately, one of my customers seems to be having this problem with the VSTO 2005 SE runtime installed. While I have successfully been able to "fix" the problem by deleting the Application Data\Microsoft\Excel\ Excel11.xlb file, I can not - as some other people have posted - use the code snippet you provided, as it will reset all toolbar customizations that my customer may have done (they are advanced Excel users and have many toolbar customizations). And forcing the customer to delete this file every time they use our VSTO solution is more than just an annoyance - it is a showstopper as they will not use our VSTO solution. Do you have any other suggestions on how to fix this issue Even with VSTO 2005 SE runtime installed Thanks, Joe. Tag: Visual Studio Tools for Office how to implement "in-Ribbon" Gallery ? Office
  - 2
    - Publishing VSTO 2005 SE addin to a network location Hi Denis, Thanks for the response. This seems to be a feasible solution. Just a few doubts, do you mean that the new application will kill all the instances of the host office application and then copy the required dlls. Also, will replacing the local copy with contents of the publish location activate the latest version or will we have to make some changes in the registry settings as well Would be great if you can share some details of what you did in the application launched. Thanks and Regards, Rakesh Tag: Visual Studio Tools for Office how to implement "in-Ribbon" Gallery ? Office
  - 3
    - WordApp.Selection.Range.set_Style throws exception I think I found the solution: the string is culture specific, I had to use the corresponding word in Hungarian (my language) intstead of "Heading" and then the element has been found. Thanks for the hints. Tag: Visual Studio Tools for Office how to implement "in-Ribbon" Gallery ? Office
  - 4
    - Excel Solver macro from VB.NET I am trying to use the Solver Add-In to solve a problem. I can run the Solver Add-In, but when I cannot use it. For example the sample usage of Solver Add-In in Excel is like this: SolverOk SetCell:="$B$1", MaxMinVal:=2, ValueOf:="0", ByChange:="$A$1:$A$3" But When I want to use the "Solverok" as a method like this: objExcel.SolverOk SetCell:="$B$1", MaxMinVal:=2, ValueOf:="0", ByChange:="$A$1:$A$3" The VB give the runtime error 438 "Object does not support the Method" What should I do Tag: Visual Studio Tools for Office how to implement "in-Ribbon" Gallery ? Office
  - 5
    - VSTO Addin crashing outlook on select machines I have created VSTO addin and have successfully deployed it to most machines in my office. The addin adds a command bar button to the standard tool bar. On select machines the addin crashes outlook on startup. I have the startup code enclosed in a try catch to handle possible errors but it seems I cannot handle this error. EventType clr20r3, P1 outlook.exe, P2 11.0.8010.0, P3 43d16d53, P4 system, P5 2.0.0.0, P6 4333ae87, P7 5a2, P8 0, P9 system.io.filenotfoundexception, P10 NIL. When I strip out all code besides a msgbox call in the application startup method, the addin starts up fine and displays the msgbox, but then when outlook is closed the addin crashes outlook in a simmilar fashion as when it crashes on startup. I have been unable to find any differences between the affected machines and other machines in the office. Tag: Visual Studio Tools for Office how to implement "in-Ribbon" Gallery ? Office
  - 6
    - Interact with MS Access using VB Hi, Is there anyway to use the database utilities provided by Access, like "Compact and Repair" using VB Tks Tag: Visual Studio Tools for Office how to implement "in-Ribbon" Gallery ? Office
  - 7
    - execute a vsto project on a remote machine Hello, I would like to execute a .docx of a word document project on a remote machine. I've installed the .vsto file both on the server and on the client machine and I've given full trust to the folder that contains the vsto project : C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727/CasPol.exe -m -ag 1.2 -url file://server/MyWordDocProject/* FullTrust But it doesn't work... :-( What else can I do Thank you in advance for any advices. mathmax Tag: Visual Studio Tools for Office how to implement "in-Ribbon" Gallery ? Office
  - 8
    - Highlighting the active field in the task pane Hi Sandeep, No. Your objective cannot be achieved. If you make all other controls disabled, they will no longer be able to respond to your click event. As an alternative way to do that, you can just set other textBox��s BackColor to be a System Control Color (Just like to be disabled). Codes I write are as follows: Code Snippet private TextBox[] txtarray = null ; private string name = null ; private void ThisWorkbook_Startup( object sender, System.EventArgs e) { txtarray = new TextBox[5]; for ( int i = 0; i < 5; i++) { txtarray[i] = new TextBox(); txtarray[i].Name = "TextBox" + Convert.ToString(i+1); txtarray[i].Text = "TextBox" + Convert.ToString(i+1); txtarray[i].GotFocus += new EventHandler(textBox_GotFocus); } this .ActionsPane.Controls.AddRange(txtarray); textBox_GotFocus(txtarray[0], new EventArgs()); Globals.Sheet1.SelectionChange += new Microsoft.Office.Interop.Excel.DocEvents_SelectionChangeEventHandler(Sheet1_SelectionChange); } void Sheet1_SelectionChange(Microsoft.Office.Interop.Excel.Range Target) { foreach (TextBox txt in txtarray) { if (txt.Name == name) { int row = Convert.ToInt32(Target.Row); int col = Convert.ToInt32(Target.Column); Char column = Convert.ToChar(col % 26 + 64); txt.Text = column.ToString() + row.ToString(); } else { } } } void textBox_GotFocus( object sender, EventArgs e) { name = ((TextBox)sender).Name; foreach (TextBox txt in txtarray) { if (txt.Name == name) { txt.BackColor = System.Drawing.SystemColors.Window; } else { txt.BackColor = System.Drawing.SystemColors.Control; } } } Hope this helps J Thanks Ji Tag: Visual Studio Tools for Office how to implement "in-Ribbon" Gallery ? Office
  - 9
    - What about Macs? Hi, Is there any way to port my Office VSTO customization to Apple Mac platform I'm completely ignorant about macs, and now I am asked about it, and I need help. So, is there the equivalent MS Office 2003 for Mac which supports customizations and also whether there is .NET framework for Mac that can run VSTO assemblies Thanks Tag: Visual Studio Tools for Office how to implement "in-Ribbon" Gallery ? Office
  - 10
    - building outlook toolbar in contacts No, a toolbar added to the Explorer window appears on the main Outlook window. The Inspector holds all toolbars for individual item windows. Tag: Visual Studio Tools for Office how to implement "in-Ribbon" Gallery ? Office
  - 11
    - Excel Automation: How to use an external link as an argument in a user-defined function? Using VSTO2005SE, I created an automation add-in that contains a user-defined function. For the sake of simplicity, let's assume the UDF takes a single cell address as its argument and then multiplies its value by 1000. Public Function MyFunc( ByVal Range As Object ) As Double Dim dblY As Double = CType (Range, Excel.Range).Value * 1000 Return dblY End Function When entered into a worksheet cell (e.g., A1: =MyFunc(B1) ), the UDF obediently takes the value in B1 and returns it, times 1000. The UDF also works fine if the value shown in B1 originates from an external link to another workbook. However, the UDF returns a #VALUE! error, if the external link is used as an argument within the function, while the other workbook is not open: =MyFunc('X:\[ExtLinkSource.xls]Tabelle1'!$A1) --> #VALUE! If the other workbook is open, the UDF throws no error: =MyFunc([ExtLinkSource.xls]Tabelle1!$A1) --> returns correct result Incidentally, this is also the standard behavior for some of Excel's built-in worksheet functions, such as OFFSET or INDIRECT - these are known to not work with external links, unless the other workbook is open, unlike SUM or INDEX. Does anybody know how a user-defined function can adopt the behavior of the SUM function and the like, i.e. retrieving a cell value from a closed external workbook I know that cell contents can be retrieved from a closed workbook using ADO.NET, but I'm looking for something not quite so clumsy. Tag: Visual Studio Tools for Office how to implement "in-Ribbon" Gallery ? Office
  - 12
    - Docx to Clean HTML Hi, I am trying to use Word 2007 and export HTML of its contents and publish it to my content management system. Right now Exporting Word using the API's is leading to incorrect HTML - like all lists are converted to P tags etc. Is there a way to generate correct HTML from Word Thanks. Regards, Saurabh Tag: Visual Studio Tools for Office how to implement "in-Ribbon" Gallery ? Office
  - 13
    - Fuzzy text in a label control Art, OK but just to satify my curiosity would be possible for You to send me a screenshot of it during runtime Thanks in advance. Tag: Visual Studio Tools for Office how to implement "in-Ribbon" Gallery ? Office
  - 14
    - Microsoft.Office.Tools.Excel Items and controls in Excel 2007 with VSTO SE Dennis, one more question about the ListObject. When you said: " I t's possible to create a ListObject, populate it with data and then disconnect the ListObject from the range (see http://xldennis.wordpress.com/2007/05/08/csv-files-listobject-controls-and-vsto/ )." you mean that it is possible to create a Microsoft.Office.Tools.Excel.ListObject The link you make reference talks about this vsto list object, created by using the Microsoft.Office.Tools.Excel.Worksheet.Controls.AddListObject method. But, since I don't have any Microsoft.Office.Tools.Excel.Worksheet in the VSTO SE Excel application-level add-in, how can I create a Microsoft.Office.Tools.Excel.ListObject On the other hand, if I use the Microsoft.Office.Interop.Excel.ListObject, to which I do have access, I lack of the data binding capabilities. Tag: Visual Studio Tools for Office how to implement "in-Ribbon" Gallery ? Office
  - 15
    - Issue in Excel report generation Hi, We recently migrated to Excel 2002 from Excel 2000 and are facing a wierd problem in the excel report generation through our Java code -- Using MIME type Excel. The issue is while generating the report after certain number of rows the values in the cells loses its numeric characteristics even though same code is used repetetively to display the all the rows. The data is absolutely fine and is working fine in Excel 2000. So it would be great if any one can help me to give an insight into what is causing this problem. Thanks in advance, Raghu Tag: Visual Studio Tools for Office how to implement "in-Ribbon" Gallery ? Office
  - 16
    - Event Handlers and UDFs in the automation add-ins Hi, Great ..thanks to this site for helping. I have an issue and have followed the following approach to create automation add-in. http://blogs.msdn.com/eric_carter/archive/2004/12/01/273127.aspx . and created following code using System; using System.Runtime.InteropServices; using Microsoft.Win32; using System.Text; using Microsoft.Office.Interop.Excel; using Excel = Microsoft.Office.Interop.Excel; using System.Reflection; using System.Diagnostics; namespace lnzv2 { [ClassInterface(ClassInterfaceType.AutoDual)] public class wsf { Excel.DocEvents_ChangeEventHandler EventDel_CellsChange; Excel.Application xlApp; Excel.Workbook xlBook; Excel.Worksheet xlSheet1, xlSheet2, xlSheet3; public wsf() { myInitialization(); } public void myInitialization() { xlApp = new Excel.Application(); xlBook = xlApp.Workbooks.Add(Missing.Value); xlBook.Windows.get_Item(1).Caption = "XL Event Test"; xlSheet1 = (Excel.Worksheet)xlBook.Worksheets.get_Item(1); xlSheet2 = (Excel.Worksheet)xlBook.Worksheets.get_Item(2); xlSheet3 = (Excel.Worksheet)xlBook.Worksheets.get_Item(3); xlSheet2.Activate(); EventDel_CellsChange = new Excel.DocEvents_ChangeEventHandler( CellsChange); xlSheet1.Change += EventDel_CellsChange; // ........question1 } private void CellsChange(Excel.Range Target ) { Target.Value2=10;; } public int NumberOfCells(object Range) { int [,] TheValues = new int[1, 1]; TheValues[0, 0] = 1; TheValues[0, 1] = 2; TheValues[1, 0] = 3; TheValues[1, 1] = 4; Excel.Range r = Range as Excel.Range; r.set_Value(Missing.Value,TheValues);//......question2 return r.Cells.Count; } } } Given question1 I am unable to invoke the event.So please give me an idea how the event can be used and correct me if i am wrong. In question2 I am unable to get the value in the cells of the given range passes in the function and it gives an error in the cell where i have written the UDF =NumberOfCells(b2:c3). Please give a heling hand. thanks. Tag: Visual Studio Tools for Office how to implement "in-Ribbon" Gallery ? Office

febwave

I have almost read http://blogs.msdn.com/jensenh/default.aspx messages all. But I don't know how to implement "in-Ribbon" Gallery (that's like home styles in word 2007 )

At "2007 Microsoft Office System UI Design Guidelines - Evaluation.doc",they said there were two styles about Gallery ,that's "dropdown " and "in-Ribbon ".Could you tell me how to set "in-Ribbon " Gallery with xml

thank you

Top

Re: Visual Studio Tools for Office how to implement "in-Ribbon" Gallery ?

Rachel Schaw - MSFT

Hi there,

In-Ribbon galleries are not suppoted in Ribbon XML. It is a commonly requested feature but not something that is available in the current extensibility model.

Thanks,

Rachel Schaw (MSFT)

Top