Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Accessing Addin methods (Excel 2000/SR1)

    How does one access a mthod or a variable that exists in an AddIn from the workbook? How does one access a method or variable that exists in the workbook from an AddIn?

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

    Re: Accessing Addin methods (Excel 2000/SR1)

    This codeline runs a sub in another workbook (test2.xls) in module1:

    Application.Run "test2.xls!module1.SubInTest2"
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    3 Star Lounger
    Join Date
    Nov 2002
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Accessing Addin methods (Excel 2000/SR1)

    Thanks. How would one get the value of a variable in an xla from a workbook or another XLA?

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Accessing Addin methods (Excel 2000/SR1)

    If the "variable" is a VBA variable, then the VBA code would have to put the value into a cell in the workbook or return it from a function.
    Legare Coleman

Posting Permissions

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