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 TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

reference solver.dll by code?

Status
Not open for further replies.
kristogi

kristogi

Chemical
Joined
Nov 21, 2004
Messages
1
Location
GR
How can I write a code for adding solver reference ?
I know that I can do it manually by clicking on it in Tools->Reference but I want to it automatically by writing code. Can I?
 
Sort by date Sort by votes

Usethe AddFromFile method to load the reference. For example on my WinXP system with Office 2003, the following statement will load SOLVER on the currently active excel project.

Application.VBE.ActiveVBProject.References.AddFromFile("C:\Program Files\Microsoft Office\OFFICE11\Library\SOLVER\SOLVER.XLA")

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

NHI
  • Locked
  • Question Question
How to convert file CADAM DRAFTING (.cdd) to file pdf by vba excel code
Replies
2
Views
1K
NHI
NHI
Kenja824
  • Locked
  • Question Question
Excel VBA Code Request
Replies
3
Views
468
Kenja824
Kenja824
kancha123
  • Locked
  • Question Question
calculation by vba
Replies
4
Views
450
davidbeach
davidbeach
SteveGregory
  • Locked
  • Question Question
Excel Command Button Code Help
Replies
16
Views
781
SkipVought
SkipVought
Kenja824
  • Locked
  • Question Question
Microsoft Outlook Code?
2
Replies
20
Views
1K
Kenja824
Kenja824

Part and Inventory Search

Sponsor

Back
Top