Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Sep 2001
    Location
    Stuck at work..., Missouri, USA
    Posts
    248
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Personal.xls (Excel 97/2002)

    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!
    <font face="Comic Sans MS">Morgan Erickson</font face=comic>
    morgan.erickson@sprint.com
    <img src=/S/flags/USA.gif border=0 alt=USA width=30 height=18>-From <img src=/S/flags/Colorado.gif border=0 alt=Colorado width=30 height=18> but living in <img src=/S/flags/Missouri.gif border=0 alt=Missouri width=30 height=18>...and working in Kansas.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Personal.xls (Excel 97/2002)

    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.I mport (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

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Personal.xls (Excel 97/2002)

    Hi,

    Take a look at <!post=this,200526 >this<!/post> post.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •