Threads Replies Last Post 4 Pages: 1  2  3  4   Excel ODBC Driver May Determine Wrong Data Type I find this article than describe exactly the same problem than I Have rigth now. Excel ODBC Driver May Determine Wrong Data Type The last review for this Article was August 19, 2003. My questio is if this is still a bug or Microsoft can fix it? Regards Jack... 1 11/20/2008 8:23:01 PM Excell 11 Type library for VB.NET 2005 Dear Friends, I'm developing a VB.NET 2005 project in windows VISTA. I add reference to Excel 11 (2003) type library. My reference seems to be made to Excel.exe and declaration appears as below: Dim myExcel As Microsoft.Office.Interop.Excel.Application but it returns exception when I try to cast excel into it as below: myExcel = GetObject(, "Excel.Application") or myExcel = GetOb... 1 10/8/2008 11:05:01 PM Eat Cookies and Loss Weight. See How Hi Cookers, Welcome to our new website, cookersworld.com. We have expanded the content links to ad Summer Weight Loss Recipes. Lose weight eating cookies and more! Get into shape for the summer! We have easy to make recipes for all weight watchers! The website is full of great links from our partners. Please stop by and support us. Visit all our links and choose the best websites ... 1 6/30/2007 8:32:30 AM Diabetic Recipes and More... Hi Cookers, Welcome to our new website, cookersworld.com. We have expanded the content links to ad Mr. Emeril Lagasse's fine recipes along with recipes for diabetic's. The website is full of great links from our partners. We have links to free cookbooks and more. Please stop by and support us. Visit all our links and choose the best recipe for you or your family. We look forward t... 1 6/24/2007 8:27:13 AM With Vista / Excel 2007 and our VBA Add-In. Hello We actually have a problem with Vista / Office 2007 and our VBA Add-In. In fact, we are an accounting software development company and have developed a add-in for accounting functions in MS Excel. This add-in is working perfectly well since 6 years and the different versions of OS and/or Office. More and more we have customers encountering troubles with this add-in... 2 6/23/2007 11:30:40 AM Determining style of cell characters for range I can determine the style of an individual character by grabbing the Active Cell's individual characters and drilling down chactert->Font->FontSyle and then determing if it is Bold, Italic or Underlined or any combination. The problem is that this must be done one character at a time. Is there a method for determine the start and end point for formatting for a cell's text conten... 1 6/20/2007 9:18:53 PM excel I would like to know how to automate the following two processes with excel: 1. I would like to take data that is obtained from sql server 2000 queries results and load the detail data onto excel spreadsheets. 2. I would also like to take data that is obtained from sql server 2000 query results and load the data in pivot tables in excel spreadheet 2003. Thanks!... 1 6/18/2007 3:56:00 AM excel ... 1 5/30/2007 8:29:29 PM Copy Paste format of charts Hi, I have a temlpate file in excel 2003 which contains some sample charts. I need to generate some charts in excel 2003 using VB.NET 2005 which has the same format as that of sample charts. ... 1 5/28/2007 6:57:01 AM Dialog name Hello, Could anyone advice on the name of the Excel dialog that lets the user select a range. TiA, Kristian... 3 5/21/2007 10:23:01 AM adding custom verb to OLE object that changes its appearance I have posted the question with the same subject and similar content to microsoft.public.vc.mfcole and - after I was asked to do that - to microsoft.public.excel.programming. There I was said to post it here. I was said that my problem appears to be a bug in Excel. Is it a place that someone will help me? Or at least give me another place on MS site where I should post it... Here's the pro... 1 5/18/2007 10:53:01 AM Exposing .Net property to VBA I originally posted this question to excel.programming, but thought someone here might be able to help. Please see the thread http://groups.google.co.uk/group/microsoft.public.excel.programming/browse_thread/thread/517ef55c1b63c39b/f1690a9fb8aa27b0?hl=en#f1690a9fb8aa27b0 ... 1 5/2/2007 8:25:00 PM Problem with Interop.Excel after uninstalling Office 2007 and installing Office 2003 I am developing a VB.Net application with VS 2005 that opens an Excel workbook and populates the worksheet with data. I started developing the application with Office 2007 installed on my Vista OS, but after I discovered that it won't run on a system with Office 2003, I uninstalled Office 2007 and installed Office 2003. I reset the reference in .Net to the Microsoft Excel 11.0 Object L... 1 5/2/2007 12:55:28 PM AccessibleObjectFromWindow to access Excel97->2007 object Hello, To gain control of a running instance of Excel, I choose to use AccessibleObjectFromWindow API to avoid mulitple instance issue. Starting from Excel 2000, I successfully retrieve IDispatch for Excel Native object (OBJID_NATIVEOM). How could I improve backward compatibility to Excel 97 ? I try : 1-> hr=AccessibleObjectFromWindow(hwnd, OBJID_WINDOW, IID_IDDispatch, (void**)... 1 4/17/2007 8:50:51 AM Attempted to write protected memory error when doing Excel automation Hello Guys, It's very strange to have such problem when i want to write an excel using C#. The program is developed in XP sp2 (english), .NET framework 2.0, Office 2003(english). It just works fine. But when i put it to XP sp2 (traditional chinese), Office 2003 (traditional chinese). NetFramework2.0, the program just gives this error, without writing anything to the excel file. ... 2 3/30/2007 3:24:04 AM Excel always running Hello, I'm programming an C# application which uses Automation. The problem is when I quit the application a ghost of excel is always running (Can be seen in all processes with th task manager). What is the solution ? Thanks... 4 3/28/2007 5:36:24 PM Problem with using created COM object with C#.NET 2005 under Excel2003 (Framework 2.0) This is part of my assembly: [assembly: ComVisible(true)] [assembly: ClassInterfaceAttribute(ClassInterfaceType.None)] // The following GUID is for the ID of the typelib if this project is exposed to COM [assembly: Guid("cd099def-f9fb-407f-b793-9db68f6b8a0b")] This is my code: using System; using System.Collections.Generic; using System.Text; using System.Runtime.InteropSer... 1 3/23/2007 3:42:47 PM To use Excel COM interop ... "To use COM interop, you must have administrator or Power User security permissions" What exactly does this mean? Surely using the Excel interop DLL doesn't require such sweeping security permissions? I'm looking to develop a software solution using Excel interop for a customer whose users have fairly constrained permissions. I'm not sure what questions I need to ask to ensure this w... 3 3/21/2007 10:47:51 AM C# + COM INTEROP + EXCEL question In excel when you run the chartwizard, there is interaction between excel and the UI of the wizard. For instance in the wizard if you click on th ebutton for 'data range' you can then select cells in excel for the range. I would like to do something similar for a Form embedded in a COM object written in C#. Can someone point me in the right direction? I really dont know what I should... 1 3/17/2007 11:07:29 PM automated Add-in for Excel I have built a automated Add-in for Excel so in functions like the Excel intrinsic functions. That is the functions operate in a cell like Sum does. I used A. Whitechapel book Microsoft .Net Development for Microsoft Office. A good book and the following his instructions it worked perfect the first time. However, there are several items I need would like to clean up. • Besides t... 1 3/15/2007 11:44:07 PM How to find / set position of a chart in a worksheet. Hi. I'm trying to set the size and position of a chart in a worksheet, se code example further down. I get an unhandeled exception then I try to access the ChartArea.Top - property within the chart. How can this be done? C# with VS 2005, .NET2.0, Office 2003. public override void ExcelReport() { System.Threading.Thread.CurrentThread.CurrentCulture = ... 1 3/14/2007 1:08:19 PM Runtime error 80010105 Running Office 2003, Win XP Home SP2. I have an Access routine that acquires data from an Excel workbook. This has been working fine until the latest Microsoft Office 2003 set of patches. Now, I get the "Server Threw an Exception" error when my code tries to open the workbook (using early binding). When I try the exact same code and the exact same workbook using Access 2000 and the Excel 9... 1 3/10/2007 9:32:18 PM Chart line colors Hi I create a few charts in code from VB.NET using the excel interops, office 2003. In my software I need to be able to set the color of the lines i.e. the color of each series on the chart. There may b e up to 9 series per chart. How do I asign a color to the series lines? thanks ... 3 3/9/2007 9:15:00 PM Excel Chart all lines are black problem Hi all We are creating a chart in an excel app that we then copy to clipboard using xlBitmap (interop). Everything works fine when we set the excelApp.Visible = true; The chart is created and copied into the clipboard. When we get it from the clipboard its colorfull und good. But when we set excelApp.Visible = false and then create the chart and copy it to the clipboard. When we then h... 1 3/7/2007 9:00:23 AM How to make all menu bars and toolbars disappear? Hello, friends, I am developing a C#.net (2005) application, in which an Excel and a Word will be launched. However, since we want to have full control on this Excel and Word from our app, I need to make all menu bars and toolbars of the Excel and Word disappear or disabled. Any ideas on how to do this? Any reference papers, sample source code? Thanks a lot.... 1 3/6/2007 7:28:00 PM 4 Pages: 1  2  3  4