ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Macro Calling Visual Basic References (https://www.excelbanter.com/excel-discussion-misc-queries/42023-macro-calling-visual-basic-references.html)

phauenstein

Macro Calling Visual Basic References
 
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.

Dave Peterson

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


All times are GMT +1. The time now is 07:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com