+ Reply to Thread
Results 1 to 3 of 3

Automation Error Library Not registered when trying to write macros for visio diagram

  1. #1
    Registered User
    Join Date
    07-30-2014
    Location
    India
    MS-Off Ver
    2010
    Posts
    2

    Angry Automation Error Library Not registered when trying to write macros for visio diagram

    Hi,

    I have the following code in excel macros
    Dim AppVisio As Visio.Application
    a = InputBox("Enter the path of the Visio Document", "VisioPath")
    Set AppVisio = CreateObject("Visio.Application")
    AppVisio.Settings.ShowFileOpenWarnings = False
    Set docObj = AppVisio.Documents
    docObj.OpenEx a, visOpenMacrosDisabled

    The line "Set AppVisio = CreateObject("Visio.Application")" throws runtime error Library not registered. I uincluded Microsoft visio library in references too. Pls help

    Thanks,
    Ramya.

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Automation Error Library Not registered when trying to write macros for visio diagram

    Works for me, if I reference Microsoft Visio 14.0 Type Library.
    There are several visio libraries available - which one are you referencing?

    Oh, and please use CODE tags when you post code.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Registered User
    Join Date
    07-30-2014
    Location
    India
    MS-Off Ver
    2010
    Posts
    2

    Re: Automation Error Library Not registered when trying to write macros for visio diagram

    I'm using "Microsoft Visio 12.0 Type Library" as i dont have Microsoft Visio 14.0 Type Library.
    I have 2010 microsoft office and 2007 visio. Any work around for this?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Create Visio Diagram from Excel
    By san1979 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-09-2014, 05:55 AM
  2. [SOLVED] VB Error Object Library Not Registered
    By Karine Rivet in forum Excel General
    Replies: 2
    Last Post: 04-11-2006, 02:20 PM
  3. VB Error Object Library Not Registered
    By Karine Rivet in forum Excel General
    Replies: 2
    Last Post: 04-11-2006, 02:20 PM
  4. Move a diagram from Excel to Visio?
    By Paul H in forum Excel General
    Replies: 3
    Last Post: 05-18-2005, 06:06 PM
  5. [SOLVED] Move a diagram from Excel to Visio?
    By Paul H in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-18-2005, 06:06 PM

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