Devam Ediyor

Excel macro (VBA) to install add-ins and references

I've written an Excel macro that requires various add-ins and references. Right now, the user has to install these add-ins & references by hand. I'd prefer that the installation be automated as part of the macro.

Here are the steps that the user currently has to carry out. I'd like a VBA macro to automate these steps:

1. On the menu bar, go to "Tools," "Add-Ins."

Check the boxes for: "Analysis ToolPak," "Analysis ToolPak - VBA," and "Solver Add-in."

2. On the menu bar: go to "Tools," "Macro," "Visual Basic Editor."

In the Visual Basic Editor, go to "Tools," "References."

Check the boxes for: "Visual Basic for Applications," "Microsoft Excel 11.0 Object Library," and "SOLVER." (it's fine if other boxes are also checked)

Close the Visual Basic Editor

Thanks!

Beceriler: Visual Basic

Daha fazlasını görün: vba install add, excel vba install add, install vba excel, install visual basic excel, excel macro installer, macro install add ins, install excel macro, macro install references, vba install excel add, vba install, add installation vba, excel vba add installation, install add excel vba, vba check references install, install macro add, vba check addins installed, installer excel macros, vba install references, macro install add, deploy excel add vb6, excel vba uninstall add, vba excel addin uninstall, install add vba, check reference installed vba, free vba addins

İşveren Hakkında:
( 0 değerlendirme ) San Francisco, United States

Proje NO: #107666

Seçilen:

dmang

I can supply the macro code you need to add the required addins. The macro will ensure that the addins are available to the user, and, if so install them. If not, post a warning. Same day turnaround.

1 gün içinde 50$ USD
(1 Değerlendirme)
1.4

7 freelancer bu iş için ortalamada 41$ teklif veriyor

ramvinod

Ok i Can do it Please let me know

1 gün içinde 50$ USD
(1 Değerlendirme)
3.3
ashishsharma1981

Can create this project in the specified time and with above excellent quality. Having experience of about 6 years in Windows Service Development, Desktop App. Development, ActiveX components development, site developm Daha fazlası

in 2 gün içinde50$ USD
(0 Değerlendirme)
0.0
mitzu

[url removed, login to view]

in 0 gün içinde30$ USD
(0 Değerlendirme)
0.0
SujataAgarwal

Should i start??

in 2 gün içinde50$ USD
(0 Değerlendirme)
0.0
MJK1982

VBA project is ready. Let me know if you want to have it.

1 gün içinde 30$ USD
(0 Değerlendirme)
0.0
venkyvenky

I can do it without any bugs! I have nearly 8 years of experience in VBA programming!

in 2 gün içinde30$ USD
(0 Değerlendirme)
0.0