Can a Macro be created that will call Visual Basic up and set the references to a specific setting? Specifically, I want to be able to create a Macro that will add-in the Solver, then open visual basic and include the Solver in the references so that the user does not have to know how to do this. Thanks.

Here's a thread with a couple of options:

http://groups.google.co.uk/group/mic...160ca766 5c10

or

http://snipurl.com/h74g

phauenstein wrote:

Can a Macro be created that will call Visual Basic up and set the
references to a specific setting? Specifically, I want to be able to
create a Macro that will add-in the Solver, then open visual basic and
include the Solver in the references so that the user does not have to
know how to do this. Thanks.

--
phauenstein

--

Dave Peterson