Hide Table of Contents

Get Sheet in Multi-sheet Drawing Example (VBA)

This example shows how to get each sheet in a multi-sheet drawing regardless whether the sheet is loaded.


' Preconditions:

' 1. Click File > Open.

' 2. Open:

' <SolidWorks_install_dir>\samples\tutorial\advdrawings\foodprocessor.sldrw

' 3. Select Selected and select Sheet1 in Select sheets to load .

' 4. Click Open.

' 5. Run the macro.


' Postconditions: Only Sheet1 is loaded.


' NOTE: Because this drawing document is used by a

'       SolidWorks online tutorial, do not save any

'       changes when closing the document.


Option Explicit


Dim swApp As SldWorks.SldWorks

Dim swModel As SldWorks.ModelDoc2

Dim swDraw As SldWorks.DrawingDoc

Dim vSheetName As Variant

Dim i As Integer

Dim bRet As Boolean


Sub main()


Set swApp = Application.SldWorks

Set swModel = swApp.ActiveDoc

Set swDraw = swModel


' Get the sheets in the drawing document

vSheetName = swDraw.GetSheetNames


' Traverse the drawing sheets and determine whether

' they're loaded

For i = 0 To UBound(vSheetName)

   bRet = swDraw.ActivateSheet(vSheetName(i))

   Dim swSheet As Sheet

   Set swSheet = swDraw.Sheet(vSheetName(i))

   'swSheet = swDraw.GetCurrentSheet

   If (swSheet.IsLoaded) Then

       Debug.Print (vSheetName(i) & " is loaded.")


       Debug.Print (vSheetName(i) & " is not loaded.")

   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 Sheet in Multi-sheet Drawing 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) 2010 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.