Programming

SOLVER Reset command does not work in 2007Excel why???? Two Questi
Private Sub CommandButton4_Click() SolverReset SolverAdd CellRef:="$B$8:$E$8", Relation:=3, FormulaText:="$B$9:$E$9" SolverAdd CellRef:="$B$8:$E$8", Relation:=1, FormulaText:="$B$10:$E$10" SolverAdd CellRef:="$F$8", Relation:=2, FormulaText:="100%" SolverOk SetCell:="$J$6", MaxMinVal:=1, ByChan... 30 May 2010 06:49

PLAY RACE GAMES
PLAY CAR RACE GAMES:- PLAY CAR RACE GAMES ON MY WEB SITE AND ENJOY UR MIND FRESH AND U CAN DOWN LOAD ALSO MY GAMES VISIT http://andhraonlinegames.blogspot,com ... 29 May 2010 17:57

Menus & Hot keys - works in Excel 2003 but not 2007
Using 2003, I have written some code in Excel VBA that puts a menu in Excel's main menu bar just before "Help". Works great. However in 2007, it does not seem to appear. The code is on the order of: iHelpIndex = cbWSMenuBar.Controls("Help").Index Set muCustom = cbWSMenuBar.Controls.Add(Type:=msoControlP... 29 May 2010 17:57

Move data between ListBoxes
I created a UserForm with two list boxes (ListBox1 & ListBox2). Right now when I show the Form ListBox1 is the only ListBox with choices inside of it. The problem I am having is that I'd like to be to be able to double click a selection from ListBox1 and have it be moved over to ListBox2. Similarly, I woul... 31 May 2010 13:05

Stopping a timer
I have this code below that runs a timer on a 30 second cycle (1 of 3 timers). My problem is that my code to stop the timer does not work, so if you close the workbook it restarts on its own. Can any one offer any help with this? I am able to stop my other 2 timers (in an effort to minimize the size of this pos... 31 May 2010 00:06

Web pop up
Hi All, I running macro to get data from web. step 1 - I will provide login info in excel step 2 - Once i run the macro, it will open the web page ( Company web) step 3 - inputs login info step 4 - goes to tab ( accounts ) step 5 - finds some accounts step 6 - clicks save to pdf account. step 7 - open new ... 29 May 2010 15:45

Auto_Open over Private Sub Workbook_Open()
I am just wondering, is there any advantage to using an Auto_Open module over just placing that code in a Private Sub Workbook_Open() module under ThisWorkbook? ... 29 May 2010 23:23

Problem with the "Or" operand in Excel
Excel 2002/3 I am trying to write a short script that looks at all cells in column C and if the cell contains a selected name (i.e., Fred or John or Mary) then the entire row is hidden I would have thought that the following would have doen it? Sub MyHideRows() Dim startrow As Integer startrow = 1 Do Unt... 31 May 2010 08:41

restrict a product eg 10*5=40 because 40 is maximum
The product of two cells is reflected in the third cell e.g. Cell C1= Cell A1*Cell B1. Cell A1 is a multiplier and Cell B2 is the amount to be multiplied. The issue is that the figure reflected in Cell C1 is an amount that is required to be paid to a particular person and the excel is to be programmed ... 29 May 2010 08:08

Need List of Embedded Files
I have a workbook with 40 +/- embedded files (Word, Excel, eMail, PowerPoint) I have been able to able to identify the Objects as "Object #" and BottomRightCell address. I appreciate any thoughts as to how get a list of the actual names of the embedded files. Thanks. ldb ... 3 Jun 2010 11:10