Sheet Sets Via Excel

I would like to utilize the Sheet Set database to drive a drawing log compiled in Excel. I am having trouble though working with sheet set objects via Excel's VBA interface. Does anyone have any suggestions?

Can I connect to a sheet set database via ADODB?

Thanks for any help

 

I'm having trouble initiating a AcSmSheetSetMgr object in excel as well, I have tried using both New AcSMSheetSetMgr and GetObject("filename", AcSmSheetSetMgr).
Has anyone succesfully connected to the sheet set manager object in excel? or gained access to the sheet set database?

 

Krispy-
No one has responded to this question yet. If I have any luck on my own I will post soemthing for you.

 

Does this help? It works in acad.

Sub test()
Dim oSMM As AcSmSheetSetMgr
Dim oDB As AcSmDatabase

Set oSMM = GetObject("", "AcSmComponents.AcSmSheetSetMgr")
Set oDB = oSMM.OpenDatabase("test.dst")
Debug.Print oDB.GetFileName

End Sub


--
----
Ed
----

have tried using both New AcSMSheetSetMgr and GetObject("filename",
AcSmSheetSetMgr).

or gained access to the sheet set database?

 

I don't believe access to the SSM object is possible outside of AutoCAD.
After all, you cannot get the object even with Visual LISP.

--
R. Robert Bell


Does this help? It works in acad.

Sub test()
Dim oSMM As AcSmSheetSetMgr
Dim oDB As AcSmDatabase

Set oSMM = GetObject("", "AcSmComponents.AcSmSheetSetMgr")
Set oDB = oSMM.OpenDatabase("test.dst")
Debug.Print oDB.GetFileName

End Sub


--
----
Ed
----

have tried using both New AcSMSheetSetMgr and GetObject("filename",
AcSmSheetSetMgr).

or gained access to the sheet set database?

 

I agree. I only mentioned it worked in acad because my initial test in xl
failed (even with acad running). I din't have time to try other methods. I
would suggest that they work from within acad and link to xl instead.

 

Thanks for trying, I was hoping to produce a drawing list in excel that will update when opened in excel. I will just have to rely on exporting the sheet list table to .csv format and setting up the data link in excel... the only problem here is that when you have the subsets as subheadings the .csv output by AutoCAD inserts spaces into the unused "merged" cells adjacent to the headings. So if you have fixed width columns in Excel the end of the subheadings are cropped because the adjacent cell is not truly empty. So I created a VB project that will strip those spaces out of the .csv, but now that is three steps to update the drawing list (four if you include the "update sheet list table" in AutoCAD)... i was hoping for just one (ie. Open the file in Excel).
thanks anyway

 

To take it one step further, I would like to allow other users to update the sheet set data (via XL or even Access) to then drive the engineers titleblock data. I don't want users to have to have Acad on their machine to do this. We currently are running a proprietary system that drives all project data via ADODB and wanted the sheet set manager to step into it's place.

 

I have developed such an app for ADT using .NET, but it uses xml. I havn't
looked into what format the ssm uses.

--
----
Ed
----

the sheet set data (via XL or even Access) to then drive the engineers
titleblock data. I don't want users to have to have Acad on their machine to
do this. We currently are running a proprietary system that drives all
project data via ADODB and wanted the sheet set manager to step into it's
place.