How to convert excel 2003 to excel 2007 template using c#
Hi, I need to built a console application that will convert all excel 2003 templates to excel 2007 template Any help is appreciated Thanks Aman ...
vsto
Invoke Excel macro recorder from code
I need a way to programatically launch the macro-recorder in Excel, and supply the name for the new macro that will get created. This can be from VSTO or VBA, or using the Office interop assemblies. Any ideas how this can be accomplished? ...
Detecting a present signature in a Word 2007 document using VSTO
I'm trying to detect a present signature in a Word document with VSTO. I am stuck, because one I don't have much experience with VSTO and second I can't find any documentation about this. What did I develop so far? Created a Ribbon Add-In for Word 2007, with two buttons. Created methods for handling the clicked buttons. When Start De...
Correlate Range.Text to Range.Start and Range.End
Hi, I'm using regular expressions to search against the plain text returned by the following property: namespace Microsoft.Office.Interop.Word { public class Range { ... public string Text { get; set; } ... } } Based upon the matches I want to make changes to the formatted text that corresponds to t...
PowerPoint Programmatically open/play mediaobject in add-in
Hi I am working on a VSTO PowerPoint 2010 add-in which will allow the user to playback a media object (video or audio) in a windows form using windows media player control. In which way can I extract the embedded media object an play it back to the user? I have access to the objects name, will that be enough to get to the embedded ob...
VSTO 4.0 Excel 2007 Add-in causing Memory leaks on Windows 7
Hi, We have a VSTO 4.0 Add-in for Excel 2007 that seems to have issues with Memory leaks, but only certain documents and only on Windows 7. The behavior is similar to the LCID proxy issue that was supposedly remedied in VSTO 4. The memory spikes at about 1.2 to 1.5 GB then throws an OutOfMemory Exception. This only seems to happen wh...
How to start a Powerpoint 2010 Slideshow using VSTO Addin
Is it possible to start a slideshow from a Powerpoint 2010 add-in? ...
performance issue regarding Open() and Add() methods in MS Word,VSTO
For Office 2007, we have the .NET component which invokes the word, it uses the Open() and Add() methods from the Word.Document. Dim wrdDoc, wrdrtf As Word.Document wrdrtf = wrdApp.Documents.Open(objRTFPath, objMissing, objMissing, False, objMissing, objMissing, objMissing, objMissing, objMissing, objMissing, objMissing, objMissing, o...
How do I display a worksheet by name using VSTO 2010 for Excel
I have never used VSTO and I am finding it difficult to find a good learning aid for 2010. My need is simple, I have a business workbook with 42 worksheets (I orignally guessed 20 but after counting found a surprising number). I want to add a ribbon (That part is easy) using VSTO to allow employees to navigate the large number of pages...
C# Excel: delegate set to capture cell selection behaves intermittently
I have created an interface to define a RangeSelectionTarget as follows: public interface IRangeSelectionTarget { void OnRangeSelection(Excel.Range target); } In another class (ExcelController, encapsulating excel interop behavior), I have a method to pipe the worksheet range selections (using the mouse to select cells) to the tar...
Compatible issue when i try to open vsto office 2007 workbook.
I have VS 2008 Pro and office 2003 Pro installed with asp.net framerwork 3.5 SP1 I am trying to open vsto office 2007 workbook project and get the compatible error. how to resolve this. ...
PowerPoint 2010 VSTO Question
How do I go next/previos slide from within the addin ...
How to create a Office Communicator Conversation Item?
Hello, I'm trying to create a Conversation Item like the ones Office Communicator saves in Conversation History in Outlook. So far I've achieved to get the mail icon replaces with the real "speech bubble" icon and the window title is also writing "Subject - Conversation(HTML)" but some things are missing. I.e. when opening the real co...
Fastest way to interface between live (unsaved) Excel data and C# objects
Hi, I want to know what the fastest way is of reading and writing data to and from an open Excel workbook to c# objects. The background is that I want to develop a c# application that is used from Excel and uses data held in excel. The business logic will reside in the c# application but the data will reside in an Excel workbook. T...
How do I sign a VSTO deployment?
Client purchased a code-signing certificate, and it came with a .pvk file and a .spc file. I am familiar with the .pvk file, but Visual Studio doesn't recognize the .spc file. When I try to load the .spc file as the ClickOnce Certificate, a message box says "The selected file does not contain a private key. You must choose a certificate...
Add controls to existing ribbon group in Office (VSTO)
I find numerous examples on how to add a new group to an existing ribbon, and this works just fine. What I cannot figure out is how I can add new controls to an existing group on an existing ribbon. Say I want to add my own command to the "Proofing" group on the "Review" tab. I'm developing this in VS2010 for Office2010, but I guess th...
Excel Visual Studio Design Time Adapter Add-in Error
Hi.. I am trying to open excel workbook 2003 using VSTO. but i am getting error again again like " Project cannot be created because the application add-in is not working correctly and might have been disabled. To check for disabled items in the Microsoft Office application, open the Help menu, click About Microsoft Office Word or Abo...
Copying shapes between PowerPoint 2007 presentations along with their animations
I programmatically copy the shapes of an entire slide to a new slide in another presentation by performing origShape.Copy and then newSlide.Shapes.Paste(). (copy/paste the entire slide is unfortunately not an option for me here) My problem is that Animation effects get really warped. Some are lost, others appear in the wrong order. I ...
How to access chart in PowerPoint via VSTO
I am trying to access charts in slides in PowerPoint 2007 via VSTO, and I am a bit confused. While the Interop provides a property Shape.HasChart which properly finds shapes that have/are charts, I can't figure out how to access the Chart itself. I don't see a chart property on the Shape. Am I supposed to cast the Shape to a specific typ...
Word 2010 addin does not load, vsto 2010
Our development machine is 64 bit hardware running Windows 7 Professional N (64 bit), 64 bit Office Professional 2010 and Visual Studio Professional 2010. We created a Word 2010 (Application Level Addin) using .net framework 4 , Ribbons and windows installer targeting Office 2010 using this link. We followed everything to the dot sever...