View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JonoB[_3_] JonoB[_3_] is offline
external usenet poster
 
Posts: 1
Default Add library in vba

Hi,

I am using Excel 2000, and have the Solver library in vba added in s
that I can run Solver from VBA. This works fine as long as the model i
run on a PC with Excel 2000.

One of my users has Excel 2003, and ofcourse the library is no
compatable. This means that he has to go an update his refernc
manually in VBA every time I update the model.

Is it possible to have excel automatically get the correct referenc
for Solver every time the model is run? Something in Workbook.Ope
perhaps?

Thanks for the help

--
Message posted from http://www.ExcelForum.com