Threads Replies Last Post 7 Pages: 1  2  3  4  5  6  7   Unexpected behavior from xlfGetBar, xlfGetCaller, and sortcut (context/popup) menus. Hello, I've been developing an XLL that creates several new menu items in Excel, each registered with the same command. This command is defined by my XLL, and uses xlfGetCaller to identify which menu item has triggered it. It then executes a C function that I have associated with the menu item's name. This has worked nicely for menu items that I've placed in the main Desktop menubar (ba... 3 5/23/2006 8:58:59 PM c# UDF as addin in Excel Hello, I have made an small AddIn with udf for excel 2003. I use vs2003. The point of view is the function __T() I call it in excel sheet writing =__T() [enter] I am not able to set a value to a given cell. region.Value2="qwe"; //bumm! A exception will be trown. On all PCs with excel. HRESULT 0x800A03EC Is it com-registration problem? But, it is possible to read the name of works... 2 5/18/2006 5:28:51 PM Laurent Longre's MoreFunc xll VSort Using Laurent Longre's xll add-in MoreFunc: http://longre.free.fr/english/ One of the functions in this will sort an array. Much faster indeed than a QuickSort. How though can I make the result of this VSort an array of longs? It seem it can only have variant arrays as the result. Thanks for any advice. RBS ... 1 5/12/2006 4:35:18 PM .NET AddIn in c# Hi @ALL, this topic is not new, but I have not found any solution. I have make an .NET c# Interop-assembly with UDF. Adding an UDF to worksheet, I can not see in Inputbox neither function description nor help link. The comments are "not available" How do I put within addin-dll description and help link to function wizard? Any c# snipped will be welcome. Thanks Frank ... 2 5/10/2006 1:42:51 PM Excel4v call fails with chkesp.c error I want to start using Excel4v to clean up function registration etc. typedef int (*fpExcel4v)(int xlfn, xloper* operRes, int count, xloper* []); fpExcel4v dExcel4v; dExcel4v = (fpExcel4v)GetProcAddress(hinstLib, "Excel4v"); Am able to load dll and fn address OK. xloper dll_name; dExcel4(xlGetName,&dll_name,0); Excel4() call works.... 2 5/7/2006 12:22:18 PM When one XLL depends on another I would appreciate any 'good practice' advice on the following. I intend to write an XLL that (because of what I would like it to do) will provide worksheet functions that only work correctly if another XLL is already loaded. That is, the new XLL will make some use of plain C functions from a primary XLL that are not Excel worksheet functions. If Excel has been configured to load both ... 2 5/7/2006 12:18:58 PM 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 4/25/2006 6:35:23 AM Getting the display value of a calling cell Hi All, How can I get the display value of a cell, if a cell has the value 12.34566778 but that cell display value has been formatted to four decimal places 12.3456. when I call that cell in my C function I get the value of the cell, not the display value. can anyone shed some light on How I can go about this. Regards Negus ... 3 4/21/2006 8:23:08 PM URGENT: ManagedXLL v.s XLL Plus Hello, I have developed a few Excel Add-Ins using Microsoft Excel SDK. I now wanted to move to something better because bare bones Excel SDK is limiting and its a pain to do complex things there. During my search I have came across ManagedXLL and XLL+ on the web. Can someone please tell me which one is better? My Add-Ins will be using MFC also for database interaction functions. An ... 2 4/20/2006 8:44:33 AM c-api:how to set toolbar button face? Hello,everyone! How can i set toolbar button face created by xlfAddToolbar(BarTex,ToolRef)? i only find the following info in "MACROFUN.HLP" for the 5th column of ToolRef indicating the face of button: "Face specifies a face associated with the tool. Face must be a reference to a picture-type object, for example "Picture 1". If face is omitted, Microsoft Excel uses the default face for th... 6 4/19/2006 9:09:16 PM c-api:how to make list-box to have multiple columns? Hello everyone! Right now i can make list-box to have only one column,i tried to make the "list" xltypeMulti xloper.val.array.column=2,but it doesn't work.this only double the length of that list and still in one column. how to make a list-box multi-column? Thanks! Best Regards! Jin Yang ... 1 4/19/2006 7:02:41 AM Show comments for .xll add-in Is it possible to make comments show under Tools, Add-ins when the .xll add-in is selected? It is no problem with .xla add-ins, but haven't found a way yet to do this with .xll add-ins. Thanks for any advice. RBS ... 3 4/17/2006 7:47:43 PM William Whooper website There used to be a good website about .xll add-ins, maintained by William Whooper, but it seems this site is down. Would this information be available from another site or will this site be available again in the future? RBS ... 1 4/17/2006 4:47:05 PM Does anyone ever use "flow" or "bigdata" type in C-API? Hello,everyone! I have tried "num","bool","int","str" and "Multi" type in c-api,but i couldn't find any document,example or tutorial for "flow" or "bigdata" type. Does anyone ever use them before? Thanks! ... 4 4/17/2006 6:45:13 AM for sale: internetDotComs.com domain for sale: internetdotcoms.com http://www.afternic.com/name.php?id=11866440 ... 1 4/16/2006 1:33:22 PM Recalculation problems with .xll user-defined functions I've noticed strange dependency update behaviour in Excel when using user-defined functions from an .xll. I expect this to be well known, but have not found anything on the web so far, so would appreciate any pointers or more information. Steps to reproduce: 1. Load the Generic.xll sample add-in from the Excel SDK. (This makes the FuncSum user-defined function available.) 2. Set cell A1 t... 2 4/15/2006 8:30:50 PM XML to Excel 2003 Hello, Does anyone know where I can get some good examples of converting and Xml document to a excel file using Xsl? Thanking you in advance. Vishal ... 2 4/12/2006 9:53:39 AM XLLs and Excel 12 Has anyone tried working with XLL and Excel 12? Do they still work? Regards, Django... 3 4/3/2006 11:24:16 PM Creating xll files with visual c++ 2005 express Hello. I am trying to use visual c++ 2005 express to create xll files so I can use my existing code for custom excel functions. I have seen one thread where there was a discussion of the issues using xlcall.h and xlcall32.lib from the excel 97 sdk even with 2003 .NET C compilers. Has anyone tried generating xll files in visual studio 2005? The xlcall.h throws a ton of errors. If any... 5 3/25/2006 7:32:06 PM Is it possible to add a dockable window to Excel? I'd like to add some interactive console functionality to Excel. While not essential, having a dockable window would be a "cool" feature to have. Has anyone heard of this being done (or possible)? ... 2 3/22/2006 7:25:19 PM Ink Sorry guys. The spam stuff was not my intent. I do oppoligies and won't happen again. I have never been on newsgroups before and not sure how to work them. I hope you guys can forgive a bad choice. Murphey... 1 3/20/2006 12:07:34 PM How to use C API to make an 'EditBox' 'password edit'? Hi,everyone Does anyone ever tried to display a dialog and enter username,password? when i use xlfDialogBox,the edit box will display whatever i typed into how can i make an editbox into a 'password edit'? thanks! ... 4 3/19/2006 12:11:22 PM Question on Paste Link and Cell XF Record BIFF8 Hello I'm writing to an Excel file and everything is working fine, but I do have a problem when I copy some cells from my file and paste them as link into a different file. I have checked the file format, and seems like I should be creating a SUPBOOK record... but looking at other Excel files not created by mi program, I can see that the difference is that Excel creates a Cell XF re... 1 3/16/2006 2:19:27 PM xlcShowToolbar misses some Hi I'm trying to control the reviewing toolbar via the C API (in Excel 2003) I'm using: Excel(xlcShowToolbar, 0, 2, TempNum(i), TempBool(1)) and looping from 2 to 125 in desperation. It shows a few toolbars but not the reviewing one I'm after. That shows up as number 7 in vba, but does not show using the C API Looking in MacroFun there is no mention of the reviewing toolbar - does this ... 1 3/14/2006 2:47:33 AM BECOME A DOT.COM MILLIONAIRE WITH ONLY $5.99Cents or $1K. ... 1 3/9/2006 8:43:55 PM 7 Pages: 1  2  3  4  5  6  7