Time-Saving Metrics on Sorting By Color 2 109 (11/19/2009 4:47:56 PM)
Hi, I am trying to find out whether metrics have been captured related to the time saved by sorting Excl text or background by color. Has anyone come across these numbers, and if so, what are they, or whe...
Henry

Get Access Data into Excel 1 147 (11/19/2009 4:22:37 PM)
Hi All, I am using excel macro to get data from access database. My sql query gives me 5 records or more than that. I am able to pull it different cells. But I want all the 5 results in single cell....
fi

Assign macro to check box? 1 580 (11/19/2009 9:28:03 PM)
Is it possible to make my macro turn on the auto filter when checked, and turn it off when unchecked? Rows("3:3").Select Selection.AutoFilter Range("A4").Select End Sub ...
Utf

Using VBA with Pivot Table Report Filter 0 1297 (11/19/2009 10:12:01 PM)
I am trying create a pivot table in Excel 2007 that only contains the new information since the last workbook-save for a non-excel-using co-worker, so she won't have to touch the pivot table. Can I manip...
Utf

Copying and Adding Values 1 145 (11/19/2009 9:24:01 PM)
I would like to create a macro to copy information from different worksheets to one single worksheet, and add the values associated with them together. I know this is a little vague, but it is pretty hard ...
Utf

VBA Format for a Range Name Used in the Sum Function 3 223 (11/19/2009 7:28:08 PM)
I am trying to run some VBA code that I would use Range names rather than a specific range, ie Data!M3:M223. MsgBox Evaluate("SUM( Data!M3:M223 )") will work, but when I change it to include the Range ...
Utf

Referenced Workbook Add-In Slow to Open in 2007 0 211 (11/19/2009 8:27:01 PM)
I have a workbook that is saved as an add-in (wbkAdd-In) and another workbook (wbkQuoteGenerator) that I assigned a reference to that add-in, because wbkAdd-In contains all the VBA code to manipulate data i...
Utf

How check if file to open is Excel or if Excel file is corrupt? 4 229 (11/19/2009 6:47:02 PM)
I'm using Excel 2003. I'm looping through a set of Excel files, opening each one and writing data from that Excel spreadsheet into a "master" excel spreadsheet. The program failed when one of the Exc...
Utf

Getting all open files in Excel 1 134 (11/19/2009 7:47:02 PM)
I am trying to get a list of all files that Excel currently has open. I say files in that it can be a mixture of .xla and .xls files (talking Excel 2003 here). I can just loop through the workbooks coll...
Utf

Book with 365 sheets?? 6 121 (11/19/2009 1:57:34 AM)
I thought I would create a workbook that contains 365 sheets (one sheet for each day of the week) that will contain rows of daily numerical data. However, if my workbook has 365 tabs, wouldn't that seem a...
Robert