Programming

Organising sales data by month
Workbook “Sales” (A1)Product (B1)Qty (C1)Date X 2 2/1/2010 X 1 10/1/2010 X 3 5/3/2010 Y 1 8/1/2010 Y 2 5/2/2010 Y 1 3/3/2010 Y 1 5/3/2010 Z 2 3/2/2010 Z 1 5/3/2010 Workbook “Report” SUMQTY (A2)Product (B2)Mar10 (C2)Feb10 (D2)Jan10 X 3 0 3 Y 2... 23 Mar 2010 13:40

Macro to copy a VLOOKUP formula - Data with a filter on
Hello, I was wondering if somebody could help me with this macro… I have some data with a filter on, so that only the rows with blank cells are showing. I want to enter a VLOOKUP in the cell, and copy it down to all the blank cells. I tried just recording a macro, but when I run the macro it doesn't work. ... 23 Mar 2010 05:39

Distinct items from recordset
Hi How to get distinct items from a recordset? Let's assume I have two columns returned from a database: countries and cities. I want to retrieve a list of unique country names. Kind regards IgorM ... 23 Mar 2010 11:20

Unable to change "Enabled" state of an Excel 2007 ribbon galle
Thanks Andy, I should have mentioned that I am explicitly calling the Set_Enabled and Get_Enabled macros. For some reason the onAction callback for the gallery is not getting called in my case. From some testing, this is what I deduce on how the getEnabled callbacks are called for the different buttons. (... 23 Mar 2010 03:27

Change color on faceid 3077
Hello I'm using faceid 3077 in a menu I have created and which works well but how do I change the color of the line? If I use the Fill Color in the normal menu in Excel, change the line color to the last used color. Is it possible to do that by VBA-code? Thanks in advance *** Sent via Developersdex... 23 Mar 2010 07:52

One step further
How can I end this code so that it will save the image in 'My Documents' instead of pasting it into the word document? It is a .gif format on the web, but it can be something else if it's easier. Thanks. "ron" wrote: On Jan 18, 12:14 pm, Southern at Heart <SouthernatHe...(a)discussions.microsoft.com> wro... 23 Mar 2010 00:09

How not to display any pop up message for macro?
When macro imports an external links into sheets, it pops up a message is about the pasting area is larger then worksheet for confirmation, does anyone have any suggestions on how not to display any pop up message for running macro? Thanks in advance for any suggestions qryConnect = "URL;http://www.mmacycle... 23 Mar 2010 00:09

make it text in vlookup
I have a vlookup table like so: 234, 112 911, 999 260/1, 888 9W2, 777 .. etc.. The lookup works fine when there is text, ie. if I pass in "9W2", it returns 777 as expected. It does not work where there are only numbers eg. 234, it doesn't recognise that it should return 112. I have tried t... 22 Mar 2010 20:41

case is string contains string?
I have played with it for an hour, but can't figure out how to make a case statement that would be something like: Case is = (string1 contains string2) Is there a way to do this? Thanks! ... 23 Mar 2010 16:00

Local cube files
Hi Is it possible to programmatically create a local cube file in Excel 2007. In Excel versions prior 2007 there was a possibility to create local cube files using a data import wizard. But in version 2007 this feature has been removed from the wizard. Despite the fact is it still possible to do that programmati... 23 Mar 2010 05:39