Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Wellington, Wellington, New Zealand
    Posts
    378
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Editing a user defined function

    I have previously created an "xlam" file containing some user defined functions. I can't work out how to edit the file (so I can changed one of the functions). Any ideas? Thanks.

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    The xlam project should be visible in the VBE if you have it loaded, so you can alter the code there and then run a line of code like:
    Code:
    workbooks("addin name.xlam").save
    from the immediate window.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Wellington, Wellington, New Zealand
    Posts
    378
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by rory View Post
    The xlam project should be visible in the VBE if you have it loaded, so you can alter the code there and then run a line of code like:
    Code:
    workbooks("addin name.xlam").save
    from the immediate window.
    When I open the xlam file, nothing appears (and nothing appears in the "Switch windows" list)???

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    You won't see it in the Excel UI because add-in windows are hidden. You need to open the VBEditor (Alt+f11), locate the add-in in the project explorer window (usually in the top left corner) and then double-click the module that you want to edit t view the code.
    Regards,
    Rory

    Microsoft MVP - Excel

  5. The Following User Says Thank You to rory For This Useful Post:

    dale.lacey (2012-11-06)

Posting Permissions

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