Hide Table of Contents

Get Material Database Paths of Document Example (VBA)

This example shows how to get the paths and names of the material databases for a document.


NOTE: Material database names must be unique. Do not re-use the name of a material database.




' Preconditions: Model is open to which a material has been applied.


' Postcondition: None



Option Explicit


Sub main()


Dim swApp                       As SldWorks.SldWorks

Dim swModel                     As SldWorks.ModelDoc2

Dim swPart                      As SldWorks.PartDoc

Dim dbs                         As Variant

Dim sMatName                    As String

Dim sMatDB                      As String

Dim bRet                        As Boolean

Dim i                           As Long


Set swApp = Application.SldWorks

Set swModel = swApp.ActiveDoc

Set swPart = swModel


dbs = swApp.GetMaterialDatabases


sMatName = swPart.GetMaterialPropertyName2("Default", sMatDB)

For i = 0 To LBound(dbs)

    If StrComp(Left(Right(dbs(i), Len(sMatDB) + 7), Len(sMatDB)), sMatDB) = 0 Then

        Debug.Print dbs(i)

    End If

Next i


End Sub


Provide feedback on this topic

SOLIDWORKS welcomes your feedback concerning the presentation, accuracy, and thoroughness of the documentation. Use the form below to send your comments and suggestions about this topic directly to our documentation team. The documentation team cannot answer technical support questions. Click here for information about technical support.

* Required

Subject:   Feedback on Help Topics
Page:   Get Material Database Paths of Document Example (VBA)
*   I acknowledge I have read and I hereby accept the privacy policy under which my Personal Data will be used by Dassault Systèmes

Print Topic

Select the scope of content to print:


We have detected you are using a browser version older than Internet Explorer 7. For optimized display, we suggest upgrading your browser to Internet Explorer 7 or newer.

 Never show this message again

Web Help Content Version: API Help (English only) 2013 SP05

To disable Web help from within SOLIDWORKS and use local help instead, click Help > Use SOLIDWORKS Web Help.

To report problems encountered with the Web help interface and search, contact your local support representative. To provide feedback on individual help topics, use the “Feedback on this topic” link on the individual topic page.