Results 1 to 15 of 15

Thread: [RESOLVED] runing an addin macro

Threaded View

  1. #1

    Thread Starter
    PowerPoster
    Join Date
    Feb 2001
    Location
    Crossroads
    Posts
    3,046

    Resolved [RESOLVED] runing an addin macro

    I recorded the following excel macro:

    VB Code:
    1. Application.Run "ATPVBAEN.XLA!Histogram", ActiveSheet.Range("$G$4:$G$8"), _
    2.         "NewName", , False, True, True, False

    I want to do this programatically from VB.

    Here is my code:

    VB Code:
    1. Set wAddin = OutputSheet.Application.Workbooks.Open(AddIns(1).FullName)
    2.  
    3.      Application.AddIns(AddIns(1).Title).Application.Run "Histogram", Sheet1.Range(strTemp), _
    4.         "NewName", , False, True, True, False

    I get the error "The macro "Histogram" cannot found". I also tried a ! preceding Histogram ... same results ..

    How can I make this work?

    Thanks in advance for any help!
    Last edited by Muddy; Aug 17th, 2005 at 07:36 AM. Reason: RESOLVED

Posting Permissions

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



Click Here to Expand Forum to Full Width