Programming

wildcard in filenames in macro
Excel 3007. I have a n application where I have several workbooks open at the same time all controled from a "Main Menu" workbook. The filenames are standard and always the same excepting for the first character which varies. I am trying to write a macro's to 1) switch between the windows and 2) to close the fil... 18 Apr 2010 11:58

Button image not loading on Custom Ribbon
I've been following Ron de Bruin's examples on creating custom ribbon tabs but I've ran into a problem. I'm trying to use my own images for the the buttons but when I replace his image with mine, no image shows in excel <button id="customButton1" label="Label 1" size="large" onAction="Macro1" image="largered1... 16 Apr 2010 11:43

Search and replace problem
Can anyone tell me why my code below only deletes data from worksheet April and not all of the selected worksheets? I intend that the TextBox1 value be found on all selected worksheets and be replaced by nothing, in effect removing the data from all worksheets. Private Sub CommandButton1_Click() x = Tex... 20 Apr 2010 16:32

grouping
I am copying some rows from one sheet to another, how can I also copy the grouping (Data>Group and Outline>Group)? Is it at all possible? Thanks, Dan ... 21 Apr 2010 03:16

Save Macro with date in name
Hi, I have a macro that I want to complete by saveing the file with the current date ate the end of the file name. I have this code but I get an error with the "DateAdd". ActiveWorkbook.SaveAs Filename:="Monthly Accrual Upload" & DateAdd ("MMMM") & " - " & DateAdd ("yyyymmdd") & ".xls", _ FileFo... 16 Apr 2010 01:52

Execute a variable as an insertion into a VBA code line
2003 & 2007 Is there a way to obtain, via Inputbox, to run the code line below: "MyToolsObject.Test" X = "MyToolsObject." & Application.InputBox("VB.NET File to test: ", "ENTER PROCEDURE NAME") Assume: X = "MyToolsObject.Test " Effectively, how can I "Execute" X as if it were the codeline below? Su... 16 Apr 2010 14:00

Array Issues… Please help me….
I am having problems with my code. It used to work fine until today. I am getting type mismatch error in f = Array("STY", "PK", "COLOR", "SZ", "ITEM", "UP", "STORE") What am I doing wrong!! Sample Code L = 0 L = ActiveCell.SpecialCells(xlLastCell).Row Dim f() As String f = Array("STY", "PK", "COLOR", ... 15 Apr 2010 18:07

Advanced Filtering top values
Basicly what I need to be able to do is to advance filter a list by the top 25 values in column E. I have a crietra that consist of filter by year, product and value . Year and Product are easy it is trying to get the list to filter by the top 25 values that is hard. What formula do I put in the critera cell that ... 17 Apr 2010 01:04

Copy and Paste using VBA.
Hi, If A1 is not blank then Copy A1 and Paste in A2:A7. I originally had simple links in cells A2:A7 that connected to A1. But sometimes one of the cells in range A2:A7 may manually have a value typed in them, which erases the link to A1. I thought trying this using VBA would eliminate the cell linkage ... 15 Apr 2010 21:30

Using Cell.Replace
Is there any way to make the What:="" be a variable? So if the variable = Test then the replace code would look for Test. Cells.Replace What:="", Replacement:="", LookAt:=xlWhole, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False ... 15 Apr 2010 17:00