Threads Replies Last Post 3 Pages: 1  2  3   COM Exception with Interop.Excel I'm trying to insert an image into an Excel cell. Please see the following code. Does anybody have a way to fix this "COMException"? I thought setting the new reference in Visual Studio took care of "wrapping" COM objects for use with .Net? I can't even get the workbook object established let alone see if the rest of this works! Imports Microsoft.Office.Interop.Excel Priva... 1 27.09.2006 15:51:02 Error messages when using SmartDDE under WinXP I receive some error messages (for example: Stack fault at position...) when I try to use Brooks SmartDDE 1.2 under WinXP. I need to control three DMFCs by means of some Excel macros calling SmartDDE. How can I solve this problem? Thanks in advance. ... 1 22.09.2006 21:24:06 Saving 2007 files as 2003 I seem to be getting a COM Exception from the following code, and I cannot figure out why: Microsoft.Office.Interop.Excel.ApplicationClass xlApp = new Microsoft.Office.Interop.Excel.ApplicationClass(); try { Microsoft.Office.Interop.Excel.Workbooks workBookSet = xlApp.Workbooks; xlApp.Visible = false; Micro... 1 14.09.2006 00:55:02 Closing workbook throws 'Exception from HRESULT: 0x800A03EC' I am developing an Office 2003 SmartDocument application where Excel charts in the document are to be populated with data from C# code. The following code handles the update of all Excel charts in the document: System.Globalization.CultureInfo ciOld = System.Threading.Thread.CurrentThread.CurrentCulture; System.Threading.Thread.CurrentThread.CurrentCulture = new ... 1 07.09.2006 12:27:02 Preventing Excel Application from closing I'm writing an MDI Windows Forms app using C++/CLI. The app uses interop to automate Excel 2000 and a number of WebBrowser controls are used to display various workbooks in child windows. Currently, I keep the Excel app window hidden from the user because I do not want him to be able to close it while my app is running. This presents a problem if the user tries opening a *.xls file by... 1 06.09.2006 14:39:02 Debugging Excel with .NET solution I have created an Office System Solution using VS 2003. it is an Excel Workbook project. When I run the project using Ctrl+F5, Excel is opened and everyting is OK. If I use F5, in order to debug the solution (DLL), Excel Starts and terminates immedietly. If I run excel and open the document that has a reference to my DLL and then try to debuf the Excel process , it wont let debug t... 1 26.08.2006 14:17:02 Exchange data from an .NET dataset with Excel 2003 VBA Hi! We have written some .NET database components which reads data from different database. This works fine and we use DataSets to send the result sets to the .NET clients. But we want to give a VBA-Programmer the opportunity to use the existing ..NET database components in Excel 2003, too. That's at all no problem to provide the VBA programmer with the services of those .NET database... 5 24.08.2006 21:09:25 PivotTables interop reference causes crash in Excel 2000 The following VB.NET code (even extracted from other actions and stripped of error handling) opens the pivot table correctly, but when I attempt to close Excel, I get an application error from EXCEL.EXE (The instruction at "0x300341b6" referenced memory at "0x650418f0". The memory could not be "read".) and the EXCEL.EXE process continues to run. Opening the report in question directly in E... 1 17.08.2006 21:59:30 Proba Proba1 ... 1 17.08.2006 10:06:52 Getting a date from a cell ( C# ) I am reading data in from an XLS file use Excel interop. I currently get cell data like this: lRange = lSheet.get_Range( lTopLeftCellName, lBotRightCellName ); Object[,] lValues = (Object[,])lRange.Value2; The problem is that columns which contain dates (formatted as m/d/y) come across as floats. i.e., 5/15/2004 comes across as 38122.0. Is there a way to programmatically know that... 3 11.08.2006 16:50:41 Pasting RTF into Excel doesn't work I'm trying to get RTF text to display as formatted text in an Excel cell. I put the text on the clipboard, select the destination cell and send the application a CTR-V. I can see the proper cell being selected. When I hit the SendKeys line, the system hangs until I do a CTR-ALT-DEL which brings up the Task Manager. I know the RTF string is in the clipboard and valid, as I can paste int... 1 26.07.2006 19:10:02 .NET Custom Control not redrawing when inserted as OleObject in Excel Hi, I created a .NET Windows Custom control and made it visible to COM. I can insert this control in a Excel Worksheet and have VBA macros interact with it fine, but the control will not redraw itself. I tried to explicitely call the Invalidate, Update and Refresh methods of the .NET control, it just won't redraw itself. Thanks for any help Virgile ... 1 21.07.2006 08:15:15 TURN $5 INTO $15,000 IN ONLY 30 DAYS...HERES HOW! This is a MoneyScheme and Not, I repeat... This is Not a Scam!!! TURN $5 INTO $15,000 IN ONLY 30 DAYS...HERES HOW! This is a Money Scheme and Not, I repeat... This is Not a Scam!!! You have most likely seen or heard about this project on TV programs such as 20/20 and Oprah, or you may have read about it in the Wall Street Journal. If not, here it is below - revealed to you in step-by-step detail. This program is by no means new. It has been in existenc... 1 17.07.2006 10:09:35 COM Interop issue Excel 2000 & 2003 Hi, I am attempting to use VB.net to drive Excel 2000. So I add reference in my project to MS XL Object Library 9.0... Everything is great, except here is the issue.... The Box I'm developing on has Excel2000 & Excel2003 installed..... I want to develop and deploy the project to the Excel2000 environment..... Is there an easy way when I create the Excel.Application object to force it... 1 08.07.2006 15:43:01 xlErr* in VB.NET Hi, I'm using VB.NET to access Excel and I'm wondering how to get information about cell errors within a range object's Value property. The following simple code gives the current selection's value in rng, but I don't get information about e.g. xlErrNum, xlErrDiv0, xlErr* as I got in VB6 (or in VBA). Is there any possibility to get the "raw" VARIANT values instead of the (from my p... 1 12.06.2006 08:42:27 Date format cells in Excel 2003 I can extract the values from Excel cells in C# using Value2. My question is how do I obtain the date format information when a double cell is formatted as a date? Thanks, Andrew... 2 09.06.2006 12:26:08 Sending Excel data on network We use Excel to aggregate and format data. We were using a separate application to send this data to a legacy server via a serial interface. We would like to update this process to send the informatin via IP. I have been digging through the VSTO documentation and I cannot find any reference to network actions. Is it possible to send dynamic data via IP? Thanks.... 1 07.06.2006 00:21:01 Creating Excel Application Object in C#? Can someone tell me how to create an Excel Application object in C#? I can create a Word and PowerPoint Application object, but when I try to create one for Excel, I get the build error: "Cannot create an instance of the abstract class or interface 'interface'" After adding the appropriate references, I use the following code to create a Word and PowerPoint Application object: Word... 1 15.05.2006 14:07:02 Automating Excel Macro linked to Bloomberg, using C# Hi, I have an Excel 2003 workbook that has links to Bloomberg using a Bloomberg add-in called blp.xla and blph.xla. I am using the .NEt Framework 1.1. I need to automate a macro residing in this workbook which opens several other files and workbooks (with their own macros) and copies/pastes data etc. I am at the point where I have the macro running, but I am having problems with the c... 2 26.04.2006 19:08:05 Make Money From Google Google AdSense is a fast and easy way for website publishers of all sizes to display relevant, unobtrusive Google ads on their website's content pages and earn money AdSense for search results pages use Google's search to provide relevant results, and the search results pages are customizable to fit with your site's theme https://www.google.com/adsense/?ai=BRRgZ9XRNRM... 1 25.04.2006 06:35:18 for sale: internetDotComs.com domain for sale: internetdotcoms.com http://www.afternic.com/name.php?id=11866440 ... 1 16.04.2006 13:33:18 Excel and Winwedge Hi, Just started using WinWedge to gather data into Excel 2000 The VB code works fine But there seems to be a couple of issues which I cannot resolve ... The Excel focus box remains on the first Cell entry (A1) and does not move. I'd like the focus to follow the entries either by focusing on the last entry or the last entry+1 Secondly, as there are 800 entries per worksheet. If poss... 1 09.04.2006 20:36:22 Info Ho aperto il mio nuovo sito è in fase di costruzione ditemi se vi piace.... www.royaldj.tk Tanti Saluti Dj Royal ... 1 08.04.2006 21:41:26 How can I find a running Excel, get the actived worksheet and access data in it Hi, I'm trying to write a small C# program to check if any Excel instance is running, whether myexcelfile.xle has been opened in one of the running instances, and then access the worksheets in that file. Any ideas? Best Regards, Gary Luo ... 2 05.04.2006 13:38:01 Excel Interop in VS2005 We have three machines with visual studio 2005 -- two Professional and one Team Edition for Developers. Office XP is installed on each of these machines and the Office XP PIAs are installed on these machines. We installed the PIAs by running the included "register.bat" file from a command prompt where either the framework 1.1 or 2.0 version of "gacutil" is in the path. On the Team Editio... 1 04.04.2006 18:46:02 3 Pages: 1  2  3