General

Cannot open 2007 excel files(.xls) as email attachments on Win. Vi
Im am running Windows Vista with Office 2007 for about 1 year with no problems. This weekend i was trying to open an excel file (.xls) attached to my email account (gmail) and I got an error message "cannot find file path....C:/users/steve/....../temporary internet files/...." If i save the file directly to m... 2 Feb 2010 17:27

Convert Time
Hello, In one cell I have the time showing (2:45:59 PM). In another cell I would like to input a formula that will convert the time into a text cell showing military time. Thanks in advance for the help. ... 2 Feb 2010 17:27

counting rows
I have 100 rows in a column A which are numbered 1 -100 in numical order. After I filter a particular item in column B which results in 20 rows (and these 20 item were scattered throughout the column), I would like column A to show 1 - 20 in numerical order. ... 2 Feb 2010 17:27

pivot table
Let me explain my situation here. I have tested few items for bacteria, yeast and mold and entered the results in cfu (or the number of bugs) on an excel 2007 spreadsheet. If the number of bugs for any of these are above 100 on an item, it would fail the test or is deemed contaminated. There are about 300 diffe... 2 Feb 2010 17:27

Look up with 2 colums and 3rows
Hello all, In sheet 1, A1 has BUE, B1 has GDL and C14.53 kilos. I need to find a match in sheet 2 to look in row A1 for BUE, B2 for GDL and then look in colums C,D,E for the 4.53 kilos. C,D, and E has 7 kilos, 5 kilos and 4.7 kilos. Thanks ... 2 Feb 2010 17:27

IF Then
Hello, and thanks for hte help. What formula do I use if in A1 I want to return TRUE, if B1 has a 1, and, return a balnk cell if B1 is blank? Thanks Jim ... 2 Feb 2010 17:27

Getting data from MS Access
Hi, i don't know if any body can helps me on this issue i wrote a code as below but no data goes to recordset i think this is because of date format or something like this because i can copy the fieds name the vaiables FrstDate shows "12/31/2009" and LstDate shows "1/28/2010" please help. Sub bbb() Dim rst... 2 Feb 2010 17:27

font color with checkbox linked cel
I change the font color in the ckeckbox linked cel to white so it doesn't show when printing. However, it works with white only. When I change the cel color to another, the font (showing TRUE or FALSE) show in black. I've changed the color of the font to match the color of the cel. I even tried the conditional ... 2 Feb 2010 17:27

How to stop: Microsoft XLS is locked for editing in 2003 Excel
Help on Office / Excel 2003 to stop the "Microsoft XLS is Locked for Editing" and then keeps showing "Read" or "Notify" from coming up almost every time Excel 2003 is opened. Thanks / shorns ... 2 Feb 2010 17:27

Emailing in excel 2003
Hi all Guru, I have created a button which emails the addresses as shown below, what i would prefer if i could have it so that it emails what ever email address is in cell B10, instead of having set email addresses. Please Help. On Error Resume Next With OutMail .To = "neil.holden(a)test.com; davi... 2 Feb 2010 17:27