Sedang Disiapkan

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!

Kemahiran: Visual Basic

Lihat lebih lanjut: vba install add, excel vba install add, install visual basic editor excel, 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, macro requires excel add ins, vba install macro add ins, vba check references install, vba install com add ins, install macro add, vba check addins installed, installer excel macros, vba install references, macro install add, deploy excel add vb6, excel vba uninstall add

Tentang Majikan:
( 0 ulasan ) San Francisco, United States

ID Projek: #107666

Dianugerahkan kepada:

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.

$50 USD dalam sehari
(1 Ulasan)
1.4

7 freelancers are bidding on average $41 for this job

ramvinod

Ok i Can do it Please let me know

$50 USD dalam sehari
(1 Ulasan)
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 Lagi

$50 USD dalam 2 hari
(0 Ulasan)
0.0
mitzu

[url removed, login to view]

$30 USD dalam 0 hari
(0 Ulasan)
0.0
SujataAgarwal

Should i start??

$50 USD dalam 2 hari
(0 Ulasan)
0.0
MJK1982

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

$30 USD dalam sehari
(0 Ulasan)
0.0
venkyvenky

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

$30 USD dalam 2 hari
(0 Ulasan)
0.0