Threads Replies Last Post 4 Pages: 1  2  3  4   DDE, OLE, Oracle Forms 6i Hello all, I am developing an Oracle Forms 6i application that reads in data from an Excel spreadsheet. There are two buttons on the form that first: show the Excel spreadsheet in an OLE container on the form, and second: read in the column headers. Viewing the spreadsheet is fine, getting data is fine, but the problem comes in how the spreadsheet is displayed after using first the Dis... 1 12/14/2005 8:27:52 PM Interop with OLE Control Hi there, I am trying to use a COM object (written in C++) from an Excel add-in in C#. So far, in every directions I looked, I have been unable to access the properties of my COM component. Here is what I did: - use Interop conversion - instantiate the class - try to access the properties (which are visible for Intellisence) -> exception "catastrophic error" - get the list of proper... 1 12/8/2005 10:48:50 PM Accessing OLE Object properties from C# Hi there, I am trying to use a COM object (written in C++) from an Excel add-in in C#. So far, in every directions I looked, I have been unable to access the properties of my COM component. Here is what I did: - use Interop conversion - instantiate the class - try to access the properties (which are visible for Intellisence) -> exception "catastrophic error" - get the list of pro... 1 12/7/2005 6:28:53 PM any Spline Interpolation function in excel?? Dear all I want to know whether there is a Spline Interpolation function I can use in excel. I searched in the help document but found that there are only linear or exponential interpolation. Is there any Spline Interpolation function like spapi in MATLAB? Any suggestion or idea will be highly appreciated! Thanks a lot!!!!!!!! JIhua... 1 11/28/2005 3:27:02 PM Creating a simple Excel addin using VB.Net - example code? Can someone point me in the direction of some sample code to create my own function in Excel, written in VB.Net. I.e., i don't want to use VBA, i have a lot of VB.Net code i want to re-use. All i'd like to find is something like a call to a function to add two cell references, eg. =MyAdd(A1,A2), with MyAdd being written in VB.Net. I can find a lot of stuff on the web about doing this s... 2 11/10/2005 8:22:55 PM Can Excel close itself Is it possible for an Excel spreadsheet to close itself? We have a problem in the Company where one user on the intranet has opened an Excel file, made changes, and then leaves it open by accident. Therefore, no one else can make changes to the spreadsheet because it is a read only file. I'm looking way "time out" the file so that after it is open for more than 15 minutes it will auto... 2 11/3/2005 9:48:08 PM Excel doesn't print, Windows Server 2003, .NET, C# Hi, I'm trying to print in a WEB project from excel. The weired thing is that in XP, IIS5 it works without any issues but in Windows Server 2003, IIS6 it jus hangs in the wb.PrintOut(..) methods (see below). I think it has to do with permission but I don't know which... Code bellow: ApplicationClass excelApp = new ApplicationClass(); excelApp.DisplayAlerts = false; ... 1 10/28/2005 1:28:45 PM CellRangeList Excell Bug Excel will create HTML files that it can not open when the sheet has data validation and is saved as a webpage and the add interactivity check box is checked. My LAN folks assure me we have have Microsoft® Internet Explorer 5.01 Service Pack 2 (SP2) or later and the Microsoft Office 2003 Web Components. I see system information Excel Version 11 build 5612 and no add ins installed.... 1 10/31/2005 5:54:28 PM 4 Pages: 1  2  3  4