[interop] Forum Topics

I prepare a table in Excel within a Using () statetement. At the end I UsedRange.Copy() to what I understand is the clipboard. Then I Selection.PasteExcelTable in a Word document. I get an COM Exception "command failed". When I activate the word document and press Ctrl+V the table gets copied. …

When I execute this progammatically, I get a table with row heights much larger than when I do this manually. Note : Sel is the Word.Selection object and the Clipboard contains an Excel Table. public void AddClipboard() { Sel.PasteExcelTable(false,false, false); var t = Sel.Tables[Sel.Tables.Count]; t.AutoFitBehavior(Word.WdAutoFitBehavior.wdAutoFitContent); }

Hi have this code that runs well for me. It's part of my WordWrapper where Sel is defined as the Selection object. I tried to save `Sel.Font to a var f` variable, and reset `Sel.Font = f`before exit, but that does not work. "Value out of range". /// <summary> /// …

This week I'll be at InterOp Las Vegas looking for the latest and coolest Linux-based technologies that InterOp exhibitors have to offer. My favorites are certainly the "new innovators." New innovators are small companies who've developed their own products and are trying to get noticed in the high-tech space. These …

Hi, Getting some strange behaviour when using Interop to create a Word document from a template. I'm using word to generate a nicely formatted and printable Receipt from Sage 200 based on a Word Template. The code should open Word then create a new document based on the template I …

I have been trying to call a C++ function in a DLL, from a C# WPF application I'm working on. I've done it before and it's worked but I can't remember how I did it and can't seem to find an example that works for me. I'm doing something wrong …

Hi, This is a problem googled easily, but no solution helped me. Locally I am trying to open a PowerPoint application to read and import a ppt (or pptx) file. this is the command where exception is thrown (ASP.NET VB): [CODE] objApplication = New Microsoft.Office.Interop.PowerPoint.Application [/CODE] the exception text is …

i created a report which exports to excel. it exports just fine. what i want to do now is merge the consecutive cells in a column which have the same values. how do i do this? please help me. this is code that generates the excel body: Protected Sub generateExcelBody(ByVal …

Hello everyone! I need to anticipate that I am very new to the Microsoft developing world, therefore I am not confident with Visual Studio. I need to write an application for a windows server that works with excel. Looking on the web I found that the best method would be …

Does anyone here know what is wrong with my code here? I am trying to write a c# library for use in VB6. I think I have tried just about everything on google and still continue to get the message "ActiveX component can't create object". I am a total VB6 …

I am facing a small problem. Something i might have mis understood. If u see the code without using a function if i print the message then i am getting proper output. But after i create Error function and print message from main function it is creating some problem. I …

Hi I had written an in VB.net that took addresses from a database put them into a csv file then took the csv file data and performed a mail merge in Word to allow the user to print them out on to an Avery L7163 label sheet. The app was …

I am using Excel interop in my VB.NET program. My problem is that I can't seem to figure out how to write to Excel *and* define the Range using numbers. Alright, so I have objects being created depending on the file that the user opens. So there could be 100 …

I have a .NET winforms app that automates Excel and checks for a worksheet password. The requirements are to be able to detect 1) that the protection is turned off 2) that the password is removed (protected but there is no password) 3) that the password matches the correct password …

I done an application using Power Point Interop library and it works well but if I copy it from DEBUG folder to another place, when I start it it gives me an error like: "Application has encountered a problem and needs to be close. We are sorry for the inconvenience". …

InterOp 2009 is a success by anyone's measure but it's been a mixed bag for me so far. Internet access on the show floor is almost non-existent. For a major tech show like this, it's absolutely ridiculous. You'd think that Internet access would be a standard feature of any technical …