Packaging Excel VBA For Distribution

[uselessnut]

Hello

I have an Excel VBA File which I want to distribute to a number of users.

The Following Excel VBA Libraries are used to:-

• VISUAL BASIC FOR APPLICATIONS

• MICROSOFT EXCEL 14.0 OBJECT LIBRARY

• OLE AUTOMATION

• MICROSOFT OFFICE 14.0 OBJECT LIBRARY

• MICROSOFT WINDOWS COMMON CONTROLS – 2 6.0 (SP6)

• MICROSOFT FORMS 2.0 OBJECT LIBRARY

Is there any method to automatically check and install the following Libraries in the client user's computer - something like packaging it as Pre-Requisite Software.

Thanks

[cytop]

Some, if not all, of those components are not re-distributable.

Your users need Excel/Office installed and you just supply the workbook.

[uselessnut]

Hello

Thanks for your reply.

Yes the users will have Excel installed and only then they can work on the Excel file.

The problem is not all users have the above stated VBA Libraries. If some libraries are missing then the VBA does not Work.

Hence, the issue is to check and install the VBA Libraries.

Thanks

[cytop]

I think what you are referring to is that the users have an earlier version of Office and this code was developed in Office 2010 so you want the users to run in the same environment.

No matter. The same applies - your users will either have to upgrade or you need to revise the code so it runs in the earlier version.

However, you should check the Microsoft site to determine which libraries can be legally redistributed.