Programming

Possible disregard formatting in exception match code?
Hi All, I have the following code to compare two lists for the same record. If the same record is found, it's highlighted (eg anders(a)gmail.edu= anders(a)gmail.edu; both get highlighted) and works perfectly. However, if the records are as follows: Anders(a)gmail.edu and andDERS(a)gmail.edu, the code doesn't matc... 5 May 2010 23:49

Linking Large Text Database to Excel
Hello, I have a large database issue I hope someone can help me with. It is hard to explain so I have tried to be as descriptive as possible without losing sight of my problem. OVERALL QUESTION Is there a way to have my Excel workbook search a very large text database outside the Excel file? I am working with a... 5 May 2010 23:49

Excel 2003 and Gantt Chart
hi How do I filter data in a worksheet (ie. quarter 1, quarter 2 and quarter 3 in the range of cells that have an age date ranges from 2004 - 2010 in excel. The worksheets has older dates to future dates to 2020. This will also create gantt chart based on the filtered data. Thank you! ... 5 May 2010 20:31

VBA used to resize objects?
i am trying to resize all objects on a sheet. is there a way to assign a variable, all the objects, rather then using the code below? 'resize charts ---> ActiveSheet.Shapes.Range(Array(4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20)).Select Selection.ShapeRange.LockAspectRatio = ms... 6 May 2010 11:57

Call Macro
Hi All, I have one main macro, I have to call another macro like this if Cells(1,"A").value = "AUSTRALIA" then Call Main_AUSTRALIA if Cells(1,"A").value = "UNITED STATES" then Call Main_UNITED STATES similarly there are 40 macros need to call. Can i code like this if Cells(1,"A").value <> "" then Cal... 6 May 2010 06:22

Create employee attendance db using personal.xls?
I have limited, beginner VBA knowledge and have been researching online for ways to create an excel 'database' for employee attendance (worked time, holidays accumulated/used, overtime accumulated/used, other types of leave accumulated/used, etc). My research has led me to the idea of using Personal.xls by cre... 6 May 2010 14:17

active window on top
hello all again!! please anybody knows the vbe command for making excel the active window on top of each other window ? tx ! paolo ... 5 May 2010 17:10

Trying to Modify Excel code; Pointing to SQL Server Instead of Acc
I played with the code here: http://www.rondebruin.nl/accessexcel.htm Got that working quick, but now I'm trying to modify the to point to my SQL Server, and having a heck of a time getting it going. In Excel, I have set a reference to 'Microsoft ActiveX Data Objects 2.8 Library' The code in 'MainMacr... 6 May 2010 14:17

remove duplicates
hi all i have in raw A phone list in raw B we have customer that ask to be removed from call list what can i do to have clean list in raw C ... 6 May 2010 17:39

Removing Command Button
Hello all, I have a code that creates a command button when the Excel file opens. The following is the code that I use: Set nBar = CommandBars("Standard") nBar.Visible = True Set nCon = nBar.Controls.Add(Type:=msoControlButton, Temporary:=True) With nCon .BeginGroup = True ... 7 May 2010 18:58