Results 1 to 4 of 4

Thread: help code vba about sheetset manager!!!

  1. #1
    Login to Give a bone
    0

    Default help code vba about sheetset manager!!!

    Hi everyone!!!

    i use AC2010-64bits. i try to code vba about Sheetset but it doesn't work and have error 429 "ActiveX component can't create object"

    Code:
    Public Sub StepThroughTheSheetSetManager()
     Dim oEnumDb As IAcSmEnumDatabase
     Dim oItem As IAcSmPersist
     '' Create a Reference to the Sheet Set Manager Object
     Dim oSheetSetMgr As AcSmSheetSetMgr
     
     Set oSheetSetMgr = New AcSmSheetSetMgr
     
     '''
     Dim oSheetDb As AcSmDatabase
        Set oSheetDb = oSheetSetMgr.GetDatabaseEnumerator().Next
     '' Get Loaded Databases
     Set oEnumDb = oSheetSetMgr.GetDatabaseEnumerator
     '' Get First Open Database
     Set oItem = oEnumDb.Next
     '' Step through the Databases
     Do While Not oItem Is Nothing
     '' Display Sheet Set File Name
     MsgBox oItem.GetDatabase.GetFileName
     '' Get Next Open Database
     Set oItem = oEnumDb.Next
     Loop
    End Sub
    i don't know how to fix it( at red line have error 429 ).....plz help me

    i refer code form here:



    thanks all!!!

  2. #2
    Administrator Ed Jobe's Avatar
    Join Date
    2000-11
    Location
    Turlock, CA
    Posts
    6,397
    Login to Give a bone
    0

    Default Re: help code vba about sheetset manager!!!

    Have you referenced the AcSmComponents XX 1.0 Type Library? Tools>References
    C:> ED WORKING....

  3. #3
    Login to Give a bone
    0

    Default Re: help code vba about sheetset manager!!!

    tks for reply Ed.
    i'm sure that i do it but i seek some forum about it and it's error for win 64bits
    can see here :
    may be i try it another program like vba excel or vb6....but i don't know how do it!!!
    tks all

  4. #4
    Administrator Ed Jobe's Avatar
    Join Date
    2000-11
    Location
    Turlock, CA
    Posts
    6,397
    Login to Give a bone
    0

    Default Re: help code vba about sheetset manager!!!

    Ah, 2010 was so long ago, I forgot about the 64bit issues.
    Quote Originally Posted by JTB World
    Unfortunately this also means that Sheet Set Manager API cannot be used in 64-bit applications because it is a COM server that cannot be called from another process as opposed to an ActiveX server.
    According to the above quote, you won't be able to access the Sheet Set api from any source. Part of this has to do with how vba was implemented in the 2010 version. Even if you tried from Excel, you still have to go through acad's vba environment. Your only solution is to upgrade acad or go back to 32 bit 2010.
    C:> ED WORKING....

Similar Threads

  1. 2013: default VP freeze behavior for viewports created with sheetset manager
    By sheridan.162739 in forum AutoCAD Sheet Set Manager
    Replies: 1
    Last Post: 2013-07-24, 09:42 AM
  2. Sheetset Manager
    By ndbrainard in forum DWG TrueView - Wish List
    Replies: 2
    Last Post: 2010-06-17, 10:50 AM
  3. populate sheetset manager with data from excel
    By elipman in forum AutoCAD Sheet Set Manager
    Replies: 2
    Last Post: 2009-11-21, 10:16 PM
  4. SheetSet Manager and EDMS
    By cadtag in forum AutoCAD Sheet Set Manager
    Replies: 1
    Last Post: 2008-04-08, 01:22 AM
  5. Sheetset manager keeps popping up
    By rekstrom in forum ACA General
    Replies: 11
    Last Post: 2008-03-20, 05:40 PM

Posting Permissions

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