Threads Replies Last Post 7 Pages: 1  2  3  4  5  6  7   Problem in Excel Saveas Method in windows 2008 server In one the web sites which we have developed, i'm creating an excel file from C#.Net 2003-ASP.NET 1.1 application. In my local machine which runs on Windows 2003 server the application works perfectly, but when I try to run the application in windows 2008 server machine it throws an exception at Exception from HRESULT: 0x800A03EC. - Microsoft.Office.Interop.Excel - at Microsoft.Off... 4 12/12/2008 10:49:40 AM XL API - how do you return the cell contents not the formula? I'm sure this is really simple, but can't quite figure it out: I have a UDF, to which I am passing a reference to a range of cells. I would like to take the value in each cell and process it within the UDF. Say for example R1C1 =MyTestLookup("TESTA","1") { result = 1; } R1C2 =MyTestLookup("TESTB,"23") { result = 3; } R1C3 =MyTestLookup("TESTC","8") { re... 4 12/10/2008 6:25:06 PM Override cell comment functionality Hi! Is it possible to write Excel Add-In to override cell comments functionality? For example, to allow rich text editing there. Thanks.... 3 12/8/2008 6:42:55 PM unique function instance identification Hi there, I have a problem I didn't find an API function for so far. In the hope that someone out there has a smart idea on how to achieve the goal I will ask the question in this group. I am working on an application that has a user defined function implemented (let's call it "foo") in a XLL. The function calculates a numerical result but by design does not get it's input data from regu... 7 12/7/2008 11:19:00 PM How to set date as result of function I have now coded an XLL with user interface, and everything is working, however I have one problem relating to dates and date formatting. I return data as an array X-Y from a UDF using the Excel API with C++. The array contains dates, integers and floating point numbers in different columns. At present I am returning dates as floats, to which formatting can then be applied. Ideally I would ... 2 11/27/2008 7:34:11 PM How to get XLL to insert formula into a cell? (xlcFormula?) I am trying to get an XLL to insert a formula into the current active cell (the formula text is autogenerated by a dialog which is selected via a menu within Excel). I have tried to use the xlcFormula command (Excel 2003) however it always fails saying that the formula text is invalid. cpp_xloper setCellOp; cpp_xloper setCellOp_Value(L"=SUM(B2:B5)"); if (xlretSuccess != setCellOp.Excel(xl... 4 11/26/2008 8:52:00 AM Problems with xlfDialog I am writing an XLL add-in with a custom dialog - DLL builds fine and gets loaded into Excel, however I am having problems with the dialog. The dialog only seems to want to display 63 or 64 controls from the [64][7] array that I have created. I can see nothing wrong with the definitions, and if I move the 'Error' row further up in the array then a different row gives the error. Are there an... 5 11/24/2008 12:24:51 PM Defined constants for Excel automation Microsoft Office support document WC0993 supplies a list of defined constants that can be used in Visual Basic and VBA applications to automate Excel. The document begins with the notice "This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated." Presumably this is because it refers to Exc... 7 11/19/2008 3:09:19 AM ooxml thirdparty C++ SDK This is a multi-part message in MIME format. ------=_NextPart_000_131D_01C943FD.90ED0890 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: base64 SGVsbG8sDQoNCkRvZXMgYW55b25lIGtub3cgYW55IGV4aXN0aW5nIEMrKyBTREsoY3Jvc3NwbGF0 Zm9ybSkgZm9yIGF0IGxlYXN0IHJlYWRpbmcgZXhjZWwgT09YbWwgZmlsZXM/ ------=_NextPart_000_131D_01C943FD.90ED0890 Content-Type: text/html; charse... 1 11/11/2008 11:01:09 AM "empty" zero element in returned xltypeMulti? dear all, i'd like to return a xloper with type 'xltypeMulti'. Lots of elements are just zeros and I'd like to make excel show them as empty cell but behavior like double zero. Setting element as xltypeNil doesnot work because excel will show 0. xltypeMissing does not work as excel shows "#Value!". xltypeError(xlerrNA) behaves correctly but excel will show "#NA". Any tricks/tips for a clean s... 6 10/25/2008 8:14:54 AM Which Excel SDK? I built an XLL years ago (in 2001) which worked when I was running Excel 2000 under Win 2000. I haven't had need of it again till recently, but when I try to open it using Excel 2003 (under XP), it's not recognized as an XLL. I am guessing I need to re-build the XLL. But when I looked for the appropriate SDK, I see one titled '2007 SDK'. My company has not yet moved to EXCEL 2007. ... 3 10/23/2008 12:20:58 AM 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:04:00 PM Should an automated version of Excel close? I'm writing an application in C++ which will read a couple of complicated text files and create an Excel worksheet containing data extracted from these files. In the process of testing, I got to the point where the program: - used CoCreateInstance() to create an instance of Excel and obtain an IUnknown interface - used QueryInterface() to obtain an IDispatch interface - used I... 4 10/8/2008 1:09:17 AM 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:31 AM debugging .xll I am having some trouble creating an xll then debugging the xll when it is used as an addin for excel. when i go to debug and have excel.exe as the target process, i am unable to create a breakpoint. in the modules screen, its says my symbols are loaded but the error is "The module did not load at the default load address" what is the problem and how can I resolve it? Thanks,... 7 6/29/2007 6:39:07 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 9 to 15 sql server 2000 queries results and load the detail data onto excel spreadsheets. Each query would be a different tab (worksheet) in the excel spreadsheet. 2. I would also like to take data that is obtained from 9 to 15 sql server 2000 query resul... 1 6/26/2007 9:32:00 PM Excel control from C++ app Short version ... I need to control Excel spreadsheet values from my own C++ Windows app. Seems simple enough, conceptually ... find an SDK that can open a spreadsheet and support GetValue(), SetValue(), etc. Ideally, it would be Excel version-independent. I'm just not seeing any approach that I can pull the trigger on. Most posts I run into actually sound like they're adding functio... 3 6/25/2007 12:31:00 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:14 AM excel question 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:58:01 AM excel 2003 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:01 AM Piratemasters1 <HTML> <HEAD> <META NAME="GENERATOR" Content="Microsoft DHTML Editing Control"> <TITLE></TITLE> </HEAD> <BODY> <P>Access the Usenet where you can download at your full connection speed. Games, movies, music and apps. 750MB in 30min at 4Mbps. Piratemasters1.com <A href="http://piratemasters1.com">http://piratemasters1.com</A>&l... 1 6/2/2007 3:50:43 PM ftyuftyu ftyijftiftkftjftyuryuiftyiftyi+ ... 1 6/1/2007 9:59:23 AM Me cago en vosotros Pues eso ... 1 6/1/2007 9:59:06 AM Excel 12 SDK What is the status regarding the upcoming Excel 12 SDK? Is it available as a beta? Thanks. Dominik ... 2 5/31/2007 6:45:19 PM failure in initiall the xlcall32.dll hi everybody: I want to know what i should do before i use the "excel4()"function. In my program, i use it directly without any other functions, and the build of the prgram has passed. But when i run it, the error message : "application initialization failure(0x0000142)" happens. i debug it for days, but i don't know why it is. yours chenqj... 2 5/31/2007 6:24:27 PM 7 Pages: 1  2  3  4  5  6  7