Personal.xls (Excel 97/2002)

Topic

New Reply

Is there any way to create something that will install a macro to the Excel personal.xls spreadsheet without me having to do it manually?

We have about 20 people who all need this macro and I’d love to say “Just run this” and have it set up automatically.

Thanks!

Reply | Quote

Replies

Place the macro in a Module and export that module to a path available to all 20 users. You can do this from the project explorer in the VBE by right clicking on the module and selecting export.

You could than save a workbook with the following code to the same location.

Sub Auto_Open
Workbooks(“Personal.xls”).VBProject.VBComponents.Import (Thisworkbook.path & “ModuleName.bas”)
End Sub

where ModuleName.bas is the name of the module you exported.

This assumes that you you users have Personal.xls open and unprotected. When your users open this workbook, their Personal.xls should be updated with the new code.

Andrew C

Reply | Quote

Hi,

Take a look at this post.

Reply | Quote