Results 1 to 6 of 6

Call addin in macro

Threaded View

  1. #1
    Registered User
    Join Date
    08-19-2012
    Location
    Germany
    MS-Off Ver
    Excel 2010
    Posts
    50

    Call addin in macro

    Ive tried the following code:
    Sub Diätplaner_Screenshot_EP()
    Dim oAI As AddIn
        Range("A1:L66").Select
        Set oAI = Application.AddIns.Add("D:\...\GraphicsExporter.xlam") ' ... is written out in my my macro, so its not the mistake :)
        oAI.Installed = True
        Application.Run "GraphicExporter.GEX_Run(control as Icontrolribbon) 'Gex_Run is the function that opens the user form of the addin. GraphicExporter is the name of the addin-workbook.
    End Sub
    Somehow it does not work. Do you know whats wrong? I get the error "the macro cant be opened. Maybe macros are disabled..."
    Last edited by Taktiker; 11-03-2012 at 05:16 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1