Programming

SaveAs in Excel97-2003 format
I am working in Excel 2000 on a machine which also has Excel 2007 installed. In a macro this line is causing Excel to crash: bk.SaveAs Filename:=excel_output_file, FileFormat:=xlNormal bk is a workbook and excel_output_file is a string ending with .xls Is there a problem with the xlNormal value? Is there a ... 27 Mar 2010 18:51

In what order do installed AddIns open?
I had no joy with my other post 'Trying to read CustomDocumentProperties of an open 2007 AddIn Options ' so I'm trying another tack... To work around a problem I'm having, since upgrading a complex tool to Excel 2007, I need to ensure that my Version Checker AddIn always opens before my Engine AddIn. Is there... 26 Mar 2010 09:11

Application or object defined error
Hi, When I run the following code, I am getting the Application or object defined error. The second line is a single line in my code. The VBE highlights the portion after "Then" in the second line. Sub Cleancolumn1() For i = 1 To ThisWorkbook.Worksheets("Sheet1").Cells(Rows.Count, 14).End(xlUp).Row If Left(C... 27 Mar 2010 09:40

Picture Form Help
Does anyone know how to change a picture within a form based on a cell reference in number? IE if cell a3=4, image1 will have a different image activated than if cell a3 returms a 7. Any Help is appreciated. Thanks Pete ... 26 Mar 2010 06:56

CDbl and "Type mismatch"
Neither of these cases work. I just get a "Type mismatch" error. Dim deg(10), min(10), sec(10), DEGt(10) as Double deg(h) = CDbl(.Cells(2 + h, 3)) min(h) = CDbl(.Cells(2 + h, 4)) sec(h) = CDbl(.Cells(2 + h, 5)) DEGt(h) = deg(h) + min(h))/ 60 + sec(h) / 3600 or deg(h) = .Cells(2 + h, 3) min(h) = .Cells(2 + ... 25 Mar 2010 22:03

formulas containing constants
Hi, it's been a long time since I have worked with formulas and I am having problem with a formula that is working with constants. My formula is: =IF(OR(B2=$G2,B2=$G3,B2=$G4,B2=$G5),"Already set up","Not set up") G2 through G5 should remain constant. What am I doing wrong? -- Kelly ... 26 Mar 2010 18:00

Locking all text, combo and check boxes
Hello, I have a user form with several text, combo and checkboxes, as well as command buttons. I would like for the user to check a check box and lock all txt,cmb and chk boxes in the form once they are entering the data, but I want to keep the cmd buttons enabled, so I do not need to lock the whole userform.... 25 Mar 2010 19:46

Filter Table based on Cell Value
I have an Excel (2007) worksheet that is linked to an MS Access (2003) table. When I refresh the data, the entire table comes over. I would like to filter this data based on the value of a cell in a different worksheet (same workbook) so that it only brings in the data for the specified value. I would also like... 25 Mar 2010 20:55

HELP: Email body transcript deleted when receiving response emails
Hi All, I am sending emails in outlook through excel with voting buttons. But once I receive the email and I vote using voting buttons in outlook, Email body history gets deleted when the voting response email is received. Is there any outlook property that I can use to keep the email body transcript from g... 25 Mar 2010 16:16

Very Easy...Right?
How do I change an existing code from... mynum = Application.InputBox("Select Submission_ID") ....to mynum is located in cell A4 on sheet 1 (ie use the number already located in A4) with no InputBox I've tried.... mynum = Worksheets("Sheet1").Cells(R4,C1) mynum = Worksheets("Sheet1").Cells(4,1).Value mynu... 25 Mar 2010 17:28