First  |  Prev |  Next  |  Last
Pages: 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72
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) anders(a); both get highlighted) and works perfectly. However, if the records are as follows: Anders(a) and andDERS(a), 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: 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
First  |  Prev |  Next  |  Last
Pages: 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72