AnsweredAssumed Answered

Macro to change sheet format on one drawing

Question asked by Gillean Gilhang on Dec 9, 2016
Latest reply on Jan 15, 2019 by Carrie Ives

Like • Show 2 Likes2
Comment • 54

Hello everyone,

I am looking for a macro that will simplify the process of changing the sheet format for each of my drawings. We want to transition from old to new template going forward, so I don't need to update old drawings, unless they get released again.

I've researched and found lots of macros to change sheet format, but most of it are batch processing a folder and I'm not really looking to do that.

All I need is a macro to change the sheet format of all sheets in the drawing currently open. I know the long way to do this (RMB, properties..etc) but essentially, since I will be doing this to all my drawings going forward, I want to automate the process and do it in a single click. Thanks in advance everyone!

Nilesh Patel Dec 10, 2016 11:13 AM

Correct Answer

Hi Gillean,

Try attached.

1. Replace "Your_Template_Name" with the name (just name) with your template.

2. Replace "Path_of_Sheet_Template" with the full path of your sheet template.

3. You may also have to change few parameters in the line 'swDraw.SetupSheet5'.

Regards,

See the reply in context

No one else had this question

Outcomes

54 Replies

1 2 3FirstPrevious

Nilesh Patel Dec 10, 2016 11:13 AM
Unmark Correct
Correct Answer
Hi Gillean,

Try attached.

1. Replace "Your_Template_Name" with the name (just name) with your template.
2. Replace "Path_of_Sheet_Template" with the full path of your sheet template.
3. You may also have to change few parameters in the line 'swDraw.SetupSheet5'.

Regards,
Attachments
- ChangeDrawingSheetTemplate.swp.zip13.3 KB
Like • Show 6 Likes6
Actions
Christian Chu Dec 10, 2016 2:00 PM
Mark Correct
Correct Answer
Gillean
You want to change sheet format on all sheets or just on current sheet?
Like • Show 3 Likes3
Actions
John Stoltzfus Dec 12, 2016 7:21 AM
Mark Correct
Correct Answer
I use this one every day and it works awesome, written by Deepak Gupta and edited by Garrett Hansen
Attachments
- Reload_All_Sheet_FormatsR0.swp.zip8.7 KB
Like • Show 5 Likes5
Actions
Gillean Gilhang @ Nilesh Patel on Dec 12, 2016 11:57 AM
Mark Correct
Correct Answer
Hi Nilesh, thanks for the macro. But after editing and running it, I get the error 'Object library feature not supported'
I am not very good with macros, so I am not too sure how to solve this error.
Like • Show 2 Likes2
Actions
Gillean Gilhang @ Christian Chu on Dec 12, 2016 11:58 AM
Mark Correct
Correct Answer
I would like to change format of all sheets in a drawing
Like • Show 1 Like1
Actions
Gillean Gilhang @ John Stoltzfus on Dec 12, 2016 12:02 PM
Mark Correct
Correct Answer
Hi John, thanks for the macro. But I'm not sure if I'm supposed to edit this first before running it? If so, I don't see any lines where I can specify the sheet format and/or file path. Please let me know how to proceed with this.
Like • Show 3 Likes3
Actions
John Stoltzfus @ Gillean Gilhang on Dec 12, 2016 12:11 PM
Mark Correct
Correct Answer
You should be able to just run it, it goes to the sheet and finds the path and reloads from there, no need to tell it where to go, it if doesn't run there may be properties that need changing..

When you edit the macro - go Tools, References and change what you need and run it, if it don't work then you'll need to contact Deepak Gupta as he might have an older version...
Like • Show 3 Likes3
Actions
Christian Chu @ Gillean Gilhang on Dec 12, 2016 12:14 PM
Mark Correct
Correct Answer
Gillean,
All you need is to specify your template block - see highlight
Like • Show 2 Likes2
Actions
John Stoltzfus @ Christian Chu on Dec 12, 2016 12:17 PM
Mark Correct
Correct Answer
You should not have to change anything, here is my list of templates - I have the same number of sheet formats and I don't need to adjust anything if I add sheet formats
Like • Show 4 Likes4
Actions
Christian Chu @ Christian Chu on Dec 12, 2016 12:19 PM
Mark Correct
Correct Answer
it's more clear if you do this:
Like • Show 2 Likes2
Actions
Christian Chu @ John Stoltzfus on Dec 12, 2016 12:22 PM
Mark Correct
Correct Answer
The problem is I'm not sure if GIllean has a set of templates as you do
So just want to make sure it's pointed to correct template
Like • Show 2 Likes2
Actions
Christian Chu @ Gillean Gilhang on Dec 12, 2016 12:28 PM
Mark Correct
Correct Answer
What version of SW are you running?
Like • Show 2 Likes2
Actions
Gillean Gilhang @ Christian Chu on Dec 12, 2016 12:29 PM
Mark Correct
Correct Answer
Hmm, I'm not sure it will work the way I want it to if I don't specify the sheet format and file path.
To clarify, we implemented a new sheet format / title block. So all of my drawings have an old format that I want to be able to change to the new one with a macro. If I don't specify the new format, I'm not sure how would it know which one I want to use? :/
Like • Show 1 Like1
Actions
Gillean Gilhang @ Christian Chu on Dec 12, 2016 12:30 PM
Mark Correct
Correct Answer
I'm using SW 2016.
Like • Show 1 Like1
Actions
Christian Chu @ Gillean Gilhang on Dec 12, 2016 12:35 PM
Mark Correct
Correct Answer
Huh... then you should be ok
Anyway, can you go to Tools>References ... and check to see if there is anything missing - see att. image
Like • Show 4 Likes4
Actions
John Stoltzfus @ Gillean Gilhang on Dec 12, 2016 12:38 PM
Mark Correct
Correct Answer
Oh oh - That is a new issue totally, never save as a new format, unless you are prepared to change every sheet out one by one, right click the sheet, properties and select the new sheet.

(unless) you take a look at #Task -

So yeah it's really easy to change out drawing formats...
Like • Show 4 Likes4
Actions
Deepak Gupta @ Gillean Gilhang on Dec 12, 2016 12:39 PM
Mark Correct
Correct Answer
You can set up the name here

For e.g. vTemplateName = "C:\solidworks\Templates\Sheet Format\Test 123.slddrt"

Make sure you specify full path of the new sheet format. The path should be in quotes as shown above.
Like • Show 3 Likes3
Actions
Christian Chu @ Deepak Gupta on Dec 12, 2016 12:44 PM
Mark Correct
Correct Answer
Also it's good idea to add revision to your template
Since even though you make change on template, but the name of your template is same as the one included in the drawing, then it won't be replaced
Like • Show 2 Likes2
Actions
Deepak Gupta @ John Stoltzfus on Dec 12, 2016 12:50 PM
Mark Correct
Correct Answer
John, the macro is to reload same format with same name. In case there is a different name then you need to specify the new name along with path.

Christian, you can reload the same sheet format bu setting first to NONE (no sheet format) and then adding again. That is what that macro does.

Gillean If the sheet format name is same has same path then macro would work fine else you need ot set the path suggested in my post above.
Like • Show 4 Likes4
Actions
Christian Chu @ Gillean Gilhang on Dec 12, 2016 12:51 PM
Mark Correct
Correct Answer
I think you'd better try the macro provided by Nilesh
Edit and change the line showed in the below image and run if it works for you, then you can go to the next step
Like • Show 2 Likes2
Actions
John Stoltzfus @ Deepak Gupta on Dec 12, 2016 1:03 PM
Mark Correct
Correct Answer
That's right - see my last post
Like • Show 1 Like1
Actions
Deepak Gupta @ John Stoltzfus on Dec 12, 2016 1:14 PM
Mark Correct
Correct Answer
John Stoltzfus wrote:

Oh oh - That is a new issue totally, never save as a new format, unless you are prepared to change every sheet out one by one, right click the sheet, properties and select the new sheet.
Why not save as new sheet format name. You can easily change that by macro OR with 2017 in one click I guess (I've not checked/tried that yet)
Like • Show 3 Likes3
Actions
John Stoltzfus @ Deepak Gupta on Dec 12, 2016 1:34 PM
Mark Correct
Correct Answer
Actually it's not really an issue today, unless you don't have access to #Task or any macros.....
Like • Show 1 Like1
Actions
Nilesh Patel @ Gillean Gilhang on Dec 12, 2016 4:49 PM
Mark Correct
Correct Answer
Hi Gillean,

Copy the codes of the macro that I supplied into notepad. Start a new macro in SolidWorks, delete everything from that new macro and paste the codes from notepad to the new macro. Save the macro and run it. It should fix the problem.

"Your_Template_Name" and "Path_of_Sheet_Template" must be inside double quotes (").

Hope this helps.

Regards,
Like • Show 3 Likes3
Actions
Christian Chu @ Nilesh Patel on Dec 12, 2016 4:53 PM
Mark Correct
Correct Answer
Good idea ! it's much simple way than searching for the obj. lib. missing !
Like • Show 2 Likes2
Actions

Incoming Links

Re: Change sheet format on open drawing with a Macro

Macro to change sheet format on one drawing

Outcomes

Attachments

Attachments

Related Content

Recommended Content

Incoming Links