Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Bobmax

  1. Bobmax

    Adding a Reference to Excel VBA using code?

    Thanks for all your help CMP, I'll give it a whirl! Bob
  2. Bobmax

    Adding a Reference to Excel VBA using code?

    Thanks for the help CMP. Your code turns on Solver in the Workbook (but you need to enter "Solver Add-in" instead of "solver.xla"). I was Ok with this - perhaps I didn't explain my problem fully. When you install the Add-in, it loads a Solver Reference in the VBA editor (Tools/References) for...
  3. Bobmax

    Adding a Reference to Excel VBA using code?

    Hi I am writing some code to automate Solver solutions on a spreadsheet. In order to make it work, I have to add the Solver Add-In form Excel and enable the Solver Reference in the VBA editor (Tools/References). My question is: Is it possible to automate the updating of the reference in VBA...
  4. Bobmax

    String variable won't work in Case statement

    Thanks guys. You're both champions! I should have asked a couple of days ago (it would have saved me quite some time!). Steve - tried yours but it still wouldn't work. Thanks anyhow. PH - Works a treat! Your assistance is much appreciated. Bob
  5. Bobmax

    String variable won't work in Case statement

    Hi (Apologies if I have posted this in the wrong area -I'm new to Tek-Tips and VBA) I am trying to reference a function variable within a case statement in the function as follows (part code only to give you an idea): Function CalcTrueScore(intRating1 as integer, intrating2 as...
See more

Part and Inventory Search

Back
Top