Programming

Ribbon Customisation
Hi All, I wanted to know what minimum software do I need to customise the ribbon? I don't have Visual Studio or any other programming tools, is VBA and notepad (for making xml files) enough? ... 19 Mar 2010 13:14

How to Reregister a given Excel version
Hi SITUATION... Two Excel version 11.0 and 12.0 are installed on a subset of machines... Depending on the last update made, one or the other is declared as the default Excel to be launch... This can be seen in the following registry key... HKEY_CLASSES_ROOT\Excel.Application\CurVer that can equal to Excel.A... 22 Mar 2010 07:11

problem with conditional formatting and VBA (excel 2007)
Hello, i have a problem with conditional formatting and VBA (excel 2007). at first here is a screenshot of my conditional formula http://img156.yfrog.com/i/bugjz.png/ as you can see, the formula depends on B1 but it is relative. so far so good. but if i go through the cells with VBA the formula for all cells ... 19 Mar 2010 06:00

How can I make this formula work?
=SUMIF(A2(LEFT(A2:A2966;9)):A2966;$K$1;I2:I2966) or should it be =SUMIF(LEFT(A2:A2966;9);$K$1;I2:I2966) I'm using this formula for as you can see nearly 3000 rows, is there another way of doing it? ... 19 Mar 2010 09:19

Can I freeze columns in a listbox
-- If the post is helpful, please consider donating something to an animal charity on my behalf .......... and click Yes ... 19 Mar 2010 06:00

Urgent Help needed!!!!
Hi, I have a problem with this: I have a worksheet named Sales historical data: Column A: Dates Column B: Phone Description Column C: Sales quantity I need to get the total sales quantity for 5 days. On the left hand side, i want to create a calender in which i can choose the date. then on the right h... 19 Mar 2010 03:49

lists not populating userform
I got help with this code from Wouter. It worked great. Then I replaced variable and object names with less generic names that follow my standard naming schema. And lost the connection between the fields and the list boxes! Code now is: Private Sub cboCode_Change() Dim rCodes As Range cboFacilities.Clear ... 22 Mar 2010 19:15

cell to have comma-delimited values based on text
I have a table called "220_reference" with a column name "Part Number" having a sample value of below: 4047122(All Dash no.), 4057222(All Dash no.), 4058222(All Dash no.), 4060122(All Dash no.) The entire value is in one cell representing the "Part Number" column(defined as general type so text I suppose). Sim... 18 Mar 2010 17:48

Closing workbook open as CSV
I open a CSV file in Excel, Copy two columns of data, paste the data into another workbook and then I want to cloes the CSV file without getting a prompt about saving the data to the clipboard. I am using Application.ActiveWindow.Close (False) to close the file but I'm still getting the prompt to save the data... 18 Mar 2010 20:07

Macro Please
Can anyone write me a macro to open multiple (but not all) hyperlinks on a worksheet, Thanks! ... 18 Mar 2010 16:39