I have heard this request many times so putting it up over here. The whole credit for this should go to Stefan Berlitz of http://solidworks.cad.de/ http://swtools.cad.de . Without his wonderful macro, this option might not have been possible.
Before starting the process I will strongly advice you to make a backup of the files.
- Open you part, drawing or assembly file from which you want to copy the Tool, Options> System Options /Document Properties Settings.
- Open the Excel based macro and choose the tab based on type of you file.
- In the Excel sheet, click on “Get. Options”. This will copy the Document Properties Settings for that particular file. Repeat same for System Options.
- Close the SW file.
- Now open you part, drawing or assembly file to which you want to copy these setting or overwrite their setting with these one.
- Go back to Excel sheet and click on “Set Options” for both System Options and Document Properties Settings.
Cool, enjoy with your new part, drawing or assembly file template.
Get the macro here: mac_copydoc.zip
Lot of thanks to Stefan Berlitz for sharing his macro. He has also explained how to use this macro in a much efficient way in the same excel file.
Run-time error ‘429’:
ActiveX component can’t create object.
Which version of SOLIDWORKS you’re trying to use it for? I don’t feel it was ever updated for higher versions.
I’m using SolidWorks 2016 – Premium and Office 2010.
For higher versions of SOLIDWORKS, you can export the Drafting standard (Tools > Options > Document Properties) and save that to an external file. And in the file you hat to apply the changes, just import that standard file.
Thanks. I realised that yesterday after struggling with the macro for a while and then reading another comment below.
Did this macro ever get updated? I need to swap templates using SW 2018 for legacy files.
I do not think it was ever updated but are you looking to update template properties OR options OR both? You can try looking at the free https://cloud.centralinnovation.com.au/WebSharpSwTask tool and I’m sure that one of the inbuilt tool (Copy document options) should help you out.
Let me know if you need further details/help.
We recently established standards for all drawings which before this did not exist. I need something that will take the information from a .drwdot file and change a legacy drawing to that new template. So I need the borders to change and everything from the entire document settings tab for a drawings. Most macos I have found can change the sheet format or load drafting standards, but simple things like colors of bend lines seem to be unable to be changed for legacy parts by a macro. Am I missing something?
Steven, I’ve not specifically checked various document setting/options but I’m sure that this can be done using macro.
Hi Gupta,
I am getting “run-time error ’76’ ” when I am trying to use your change sheet format.swp macro. My SolidWorks version is 2012 and my Mircrosoft Office is 2007 and my Visual Basic is 2005. Could you please help me out because I would love to use this macro
Let me test the macro on SW2012/2013 and I’ll get back to you.
Did you get your question resolved? I’m also running 2012 and need to swap out templates on our existing drawings. Just want to be clear about templates (DRWOT) vs. formats (SLDDRT) it seems I can already swap formats from the document properties window—-I need to swap a custom made template—-Am I in the wrong place?
No but there is no direct way to swap templates but you can the options from one to another using the macro stated in the post.
Michael, can you share the path of the macro which you’ve tried and getting the error.
Hmmm.. I tried this and get an error ‘run time error ’76’, path not found.
What is your SolidWorks and MS office version version.
Which line it showed the error.
It all seemed to work fine in the excel doc, however the drawing border didn’t change in the drawing I was trying to update the template on. : ( Does anyone know why this might be?
This macro is to change the system and document options and not the tempplate/sheet format. If you looking to do that try this macro: Change_Sheet_Format.swp
Bravo, what words… a remarkable idea
Nice tool for Swaping the template.
Easier and faster.
Thanks.
Hi,
Do u have the Drawing template with u as per iso standards
Can u send me.
No but you can refer to a design handbook to set your templates or use the standard ISO templates available in SolidWorks
this works perfect. very useful macro..
mark 🙂
Paul, very good advice. It’s faster and far better than macro discussed above.
Sonu
Now you can accomplish this same thing with Drafting Standards for Parts, Assemblies, and Drawings. For system options you can use the Copy Setting Wizard
Paul,
This is mostly useful for the people with older SW versions and I find it quite handy too.
Very nice advice here Deepak, I’ll go give it a try. Thanks.