topic Re: Loop through sheet set in .NET Forum

Loop through sheet set

Anonymous — Wed, 07 Oct 2015 12:15:15 GMT

I have around 200 drawings in subset of a sheet set. Half of the sheet numbers are just numbers and the other half are numbers with a D at the end. I want to add a dash before the D if the sheet number has one. Basically, I need to make this

1
1D
2
2D
3
3D

look like this

1
1-D
2
2-D
3
3-D

I think only VBA has access to edit the sheetset so a lisp can't be used. I can write the loop to work in excel VBA, but I'm having trouble in autoCAD VBA because I don't know how to call out all of the sheets in the subset or the property that needs to be changed (the sheet number).

Re: Loop through sheet set

Anonymous — Wed, 07 Oct 2015 14:03:39 GMT

I'm not sure if this will help at all but this is what I wrote that works in excel VBA. The lines in red are what need to be changed.

Public Sub Demolition()


 For Each cell In Range("E6:E13") 'Need to define every sheet in a subset
 
 If Right(cell.Text, 1) = "D" Then 'Need to call out the sheet number property
 
 cell.Value = Left(cell.Text, Len(cell.Text) - 1) & "-D" 'Same as above
 
 End If
 
 Next cell
 
 
End Sub

Re: Loop through sheet set

Jeff_M — Wed, 07 Oct 2015 16:47:07 GMT

This old Autodesk University class should give you the infomation you need.