I am trying to work out a solution to share most of my VBA codebase across workbooks. This involves creating a .xlam file that would contain the shared modules & classes (+ their respective factories). I'm willing to use Office 2007's wonderful RibbonUI, and have that .xlam file declare a custom tab (Let us call it MyTab for the sake of...
Could someone please explain to me the difference between the combo box that's available via the Developer Ribbon in Excel 2007 vs. the Combo Box control that's in the VBA editor? I cannot get this simple line of code to work using the Developer combo box: MsgBox Combo1.Value I've tied it to the change event and it seems to be syntact...
I have column A B C D how to search in Excel (not csv) if "test" in column A - and if found I want to receive A B C D column's thanks for any help ...
http://s3.amazonaws.com/alexa-static/top-1m.csv.zip on that Alexa domain ranking spreadsheet (top 1 million domains in the world) A column contains domain ranking, B column contains domain name (for those not familiar) On a D column, I put =VLOOKUP("dog",A1:B1000001,1,TRUE) and it returns #N/A How come Vlookup is not working ? Usin...
in excel 2003 row,column addresses are specified like A,1 and C,12 but in excel 2007 this format changed to integers like 1,1 and 3,12 is there any built in support for converting old address to new one or is there any custom algorithm to convert these values. thanks in advance ...
I am running into an issue with Excel 2007 via VSTO 3.0. In my project, I need to shuffle columns around occasionally. Normally, this works fine but I have recently found that an issue arises when the data is filtered and the fitlered data is non-contiguous. For example, using this data set: Ohio Eastern Kentucky Eastern Ill...
hi How to run over DataSet and insert into Excel (not .csv file) ? i work on C#, Visual-studio 2008, Excel 2007 thank's in advance ...
Date | data | data | data 12/29| G | F | G 12/30| G | | I have a spreadsheet like above. I want to find the row that is the current date, then reference the row that is the current date in a Range type. Then cycle through the data in that row. I can find the current date, and get the address of the cell that is the cu...
I have a TreeView in excel 2007 with checkboxes. I want the checkboxes to be all selected when the tree is populated I want that when I select/unselect a parent node of the list, all its children are selected/unselected Here is the code I have written so far: Private Sub UserForm_Initialize() 'Set control defaults With Me ....
Hi, I have created an ODC file with connection to SQL server. I am running an Stored Procedure in the command text of the connection file. The Procedure has 2 parameters which is hard coded in the command text. The problem is, Every time i have to run the ODC with new set of parameters, i need to change it in the file's commandText. Is ...
Hi, as a workaround for the Locale bug in Office Interop I wanted to use VSTO but if I call app.ActiveWorkbook.GetVstoObject() then it returns nothing. I'm working from a .NET 2.0 Visual Basic Application project. This is not an add in or a special VSTO project. I have added the required Imports and References. Dim app As New Excel.A...
When VSTO code creates a list object and applies a table style in Excel 2007, the Table Tools/Design tab is activated automatically. When the user then selects a non-table cell, the Home tab is activated by default. Is there a way to either suppress this behavior or reset the active tab to the custom tab that started the action? What ...
Hi, can somebody tell me what's the equivalent of SQL.Request() method in excel 2007? It seems the add-in doesn't come built-in as part of excel versions after 2002. What's the solution for this ?? ...
I just started using the new POI 3.6 http://poi.apache.org XSSF which was released in December 2009. The updated API provides support for reading and writing in the OOXML spreadsheet format (.xslx) with Java. So far I've been pretty impressed with the API and haven't really encountered any issues with it. What issues or gotchas have you...
I am using Excel to store a list of products, that will be then used to import into a web application. One of the attributes of a product is colour, which is to be selectable from a defined list of colours. The issue is that there can be multiple colours for a product. At present, I am using a dropdown list, which is on each row for a pr...
Hi, I want to create a Method in Excel Add-In 2007 solution which can be called from my Excel Workbook 2007 solution. I explain, I want to call a method of Excel Add-In from code behind file of excel workbook 2007 solution. And I dont want to use VBA Macros. Please help, thanks in advance Thanks, Mrinal Jaiswal ...
I have a column of numbers in Excel 2007, for example: 19 35 29 62 What i want to do is: If the value is between 0-20 replace the value with 0.1 If the value is between 20-25 replace it with 0.2 The bin sizes are not going to be the same (0-20, 20-25, 30-50, 50-60, 65+) etc, and the values to replace the numbers with are not necessar...
Sheet1 column B contains my customer number- I need to locate this customer number in Sheet2 column F. Then copy the value from Sheet2 AE (from the row with the matching customer number) into the matching customer number row in Sheet1 column E. Note that sheet1 column B and Sheet2 column F contain the same customer numbers, but not in ...
Is there a way to make values in a cell that are comma delimited (ex. cat, dog, fish) became separate labels in a pivot table instead of getting labels like 'cat, dog', 'fish, cat', 'cat, dog, fish' which represents the exact value in the cells. The only real option I can think of would be to make an extra rows with the same data for ea...
Is there any way to change the color and/or font of specific text within an excel cell? That is, I'd like one part of the cell's displayed value to be red and another part of the same cell's displayed value to be blue (as an example). Since the displayed values are being calculated as formulas, I'd need some sort of formatting formula ...