AnsweredAssumed Answered

Need help modifying a "sheet format update" macro

Question asked by Taylor Rucker on Sep 2, 2015
Latest reply on Feb 21, 2017 by Elisabeth Daley

Like • Show 1 Like1
Comment • 27

I have hundreds of blueprints already created with multiple sheet formats throughout the bunch. All of the sheet formats were modified from one original that just happened to have a typo. Long story short I'm having to go through and modify the sheet formats. I found one of Deepak's macros that works pretty well for this. However I need to make a few changes and haven't had any luck doing it on my own yet. I need to be able to browse for the path name of where my sheet format is and browse for the sheet format .slddrt file. Currently both of these are static. I also need to be able to choose multiple folders when deciding what folder to update, rather than just one. I will include the macro as it currently sits, please feel free to ask questions about anything that I didn't make clear.

Thanks,

Taylor

Leon Wurr Sep 2, 2015 9:36 PM

Correct Answer

Did you read this thread:?

template update for drawings

There's something similar to what you're asking there:

See the reply in context

Attachments

Update Sheet Format.swp.zip15.5 KB

No one else had this question

Outcomes

27 Replies

1 2FirstPrevious

Leon Wurr Sep 2, 2015 9:36 PM
Unmark Correct
Correct Answer
Did you read this thread:?
template update for drawings

There's something similar to what you're asking there:
Attachments
- Change_Sheet_Format_v2.1.zip56.7 KB
Like • Show 0 Likes0
Actions
Taylor Rucker @ Leon Wurr on Sep 2, 2015 9:59 PM
Mark Correct
Correct Answer
Thanks for answering so quickly Leon!

I ended up using your version 2.0 instead of 2.1 as I do not need to change the sheet size. Is there anyway that it could be modified so that the folder we want updated will also include sub folders? The current macro will save me MANY hours, but if the macro could update all of the sub folder locations as well, that would be absolutely fantastic.

Thank you for your help!

Taylor
Like • Show 0 Likes0
Actions
Leon Wurr @ Taylor Rucker on Sep 2, 2015 10:07 PM
Mark Correct
Correct Answer
    I'm working on it.

    Can you send me your sheet template so I can run some tests? (I'm worried that it won't work if you're not using standard A0,A1... sheet sizes)

    Feel free to remove sensible data from it as your company name/logo/etc..

    Also, it was not very clear if there's multiple sheet sizes or just different sheet templates but with the same size.
Like • Show 0 Likes0
Actions
Taylor Rucker @ Leon Wurr on Sep 2, 2015 10:13 PM
Mark Correct
Correct Answer
Attached is the updated sheet format that I need. There are multiple sheet formats, the only thing that changes between them is locations of blocks, specs, etc. All of the sheet sizes are the same.

Thanks again!
Attachments
- Example.slddrt.zip59.6 KB
Like • Show 0 Likes0
Actions
Taylor Rucker @ Taylor Rucker on Sep 2, 2015 10:23 PM
Mark Correct
Correct Answer
I'm sure you are already aware, but when I run the macro with this sheet format, the resulting sheet is re-sized and too small. I am trying to figure it out now but if you could help me with that too I would greatly appreciate it!
Like • Show 0 Likes0
Actions
Leon Wurr @ Taylor Rucker on Sep 2, 2015 11:19 PM
Mark Correct
Correct Answer
     I'll fix the sizing issue in the updated version, and I'll take a different approach so that you can use templates that are different, but with the same size.

     One last question, do the updated templates have the same name and are located in the same place as the old ones (with the typo)?

     Tomorrow morning I'll post the updated version of the macro.
Like • Show 0 Likes0
Actions
Taylor Rucker @ Leon Wurr on Sep 2, 2015 11:41 PM
Mark Correct
Correct Answer
I have been editing the sheet format to fix the typo and then saving them in the same location as the old sheet format. I just figured out the sizing by using swDwgPapersUserDefined and 11x17. The problem I am running into now is that I don't want all sub folders to be updated. I know I'm being a pain in the butt. The way our file structure works, we have size A, B, and C, Each having requirements 1,2, and 3. Is there any way I could choose specific folders to apply the update to? I'll try to explain better,

Part X
     Size A1
     Size A2
     Size A3
     Size B1
     Size B2
     Size B3
     Size C1
     etc.
Part Y
     Size A1
     Size A2
     Size A3
     Size B1
     Size B2
     Size B3
     Size C1
     etc.

I need to apply the update to Part X: A1, B1, and C1 all at the same time. Likewise for Part Y and so on.

Thank you so much for your help.
Like • Show 0 Likes0
Actions
Leon Wurr @ Taylor Rucker on Sep 3, 2015 8:05 AM
Mark Correct
Correct Answer
     Well, the macro was not supposed to be searching in sub-folders for files, that's odd, don't you mean that you don't want the other pages of the same drawing to be updated?

     Anyway, this should do the trick, change this lines on the macro:

                    bRet = swDraw.SetupSheet5(strNameSheets(j), intSize, swDwgTemplateCustom, varSheetProps(2), varSheetProps(3), varSheetProps(4), strSource, varSheetProps(5), varSheetProps(6), "Default", True)
                    If bRet = False Then
                        MsgBox "Something went wrong :(, check if the Change_Sheet_Format_v2.1.slddrt file is missing"
                        End
                    End If
                    bRet = swDraw.SetupSheet5(strNameSheets(j), intSize, swDwgTemplateCustom, varSheetProps(2), varSheetProps(3), varSheetProps(4), UserForm1.TextBox1.Value & swSheet.GetSheetFormatName & ".slddrt", varSheetProps(5), varSheetProps(6), "Default", True)
                    If bRet = False Then
                        MsgBox "Something went wrong :(, ending macro."
                        End
                    End If
                    swModel.ViewZoomtofit2
                Next j

     The things in red are the ones that changed. This change assumes that the template you're trying to update has the same name and is located in the same path as the template already applied to the drawing, i.e, the sheet template did not change location or name, it has only been edited.

     This command "swSheet.GetSheetFormatName" will get you the name of the applied sheet template on the current page of the drawing.
Like • Show 0 Likes0
Actions
Taylor Rucker @ Leon Wurr on Sep 3, 2015 2:38 PM
Mark Correct
Correct Answer
I was actually using version 2.0 of your macro. You are correct, I do need it to update all sheets in the drawing file. However I also want to be able to choose multiple folders to apply the update to. If I have two or more folders with different file paths that I want to update, I want to do them at the same time Rather than running the macro again.
Like • Show 0 Likes0
Actions
Leon Wurr @ Taylor Rucker on Sep 4, 2015 11:49 AM
Mark Correct
Correct Answer
I've updated it, now it has an option to just "Reload" the pages, but for it to work:
- The sheet's template name must remain the same as the old one
- You can change the location of the templates just by inserting the new path into the first step
Another option added was to search on subfolders (it supports only 2 levels of subfolders).

If you have any issues please describe them here.

Moh AA and John Stoltzfus check out this version, see if it suits your needs.
Attachments
- Change_Sheet_Format_v3.0.zip62.8 KB
Like • Show 3 Likes3
Actions
John Stoltzfus @ Leon Wurr on Sep 4, 2015 3:14 PM
Mark Correct
Correct Answer
I will test it later - Thanks
Like • Show 0 Likes0
Actions
John Friesen @ Leon Wurr on Jan 5, 2016 10:18 AM
Mark Correct
Correct Answer
Hi Leon, are you able to help me with this macro? it looks very well built but unfortunately it is not working and returns with the error " Something went wrong ;(, check if the Change_Sheet_Format_v2.1.slddrt file is missing" what do i need to do? TIA
Like • Show 0 Likes0
Actions
Zhuk Daniel @ Leon Wurr on May 25, 2016 10:23 AM
Mark Correct
Correct Answer
Great macro, thank you very much Leon! Was having the same situation as Taylor.

However, I can't seem to get the 'reload' function to work. I'm using your macro program (v3) to update all the sheet formats to the updated sheet format version. The sheets in the drawing seem only to update if I fill in step two of the macro, but do not update if I only use the 'reload' function. (Filled in the updated sheet format path in step one, and filled in the drawing path in step three.)

What am I doing wrong that the 'reload' function does not work?
(My situation: I updated something in a sheet format I'm using in all my drawings, and saved it under the same name.)

Thanks a lot!!!
Dan
Like • Show 0 Likes0
Actions
Deepak Gupta @ Zhuk Daniel on May 25, 2016 11:20 AM
Mark Correct
Correct Answer
Save new format as different name else it may not work.
Like • Show 0 Likes0
Actions
John Stoltzfus Jun 22, 2016 1:37 PM
Mark Correct
Correct Answer
I finally found a macro that works, or rather I found out what I was doing wrong .....

I use multiple sheets drawings, so I'll have up to 7 or 8 different sheet formats in the one drawing file. The last few years there were multiple changes to the template and even name changes to the templates, this was a big issue here. When you keep the same templates in the same template folder this macro works very well....

Written by Deepak Gupta and edited by Garrett Hansen
Attachments
- Reload_All_Sheet_FormatsR0.swp.zip13.4 KB
Like • Show 3 Likes3
Actions
Ryan Windgassen @ John Stoltzfus on Jul 29, 2016 2:57 PM
Mark Correct
Correct Answer
Thanks John. This is exactly what I needed. I couldn't get Leon's to work with my templates stored in EPDM.
Like • Show 0 Likes0
Actions
John Stoltzfus @ Ryan Windgassen on Jul 29, 2016 3:20 PM
Mark Correct
Correct Answer
You're welcome - if you have a need for an awesome macro from Leon Wurr that counts the multiple sheet tabs for the SHEET 1 OF 10 etc.. this macro omits any of the tabs that have the word COVER in them. Here it allow us to have all of our ECN - ECR - Assembly Notes and other cover sheets that we need, these stay with that assembly and is part of the drawing file, no need to remember to open up numerous drawings etc...
Attachments
- CustomSheetNumber.zip18.7 KB
Like • Show 1 Like1
Actions
Prasanna Ashok @ Leon Wurr on Jan 24, 2017 6:03 AM
Mark Correct
Correct Answer
Hi Leon,

When i click on "Set Sheet format folder", i get the following error. My .slddrt files are placed in the given path only, but still i get the error. Can you please help me on this?

Below is my requirement.

Dear All,

I have checked many macros in the forum, but either i get error or not working.

Below is my requirement:

I have 300 drawings (250 part drawings and 50 assembly) in a folder. Now the drawings are created in Vendor sheetformat. I need to change the drawing sheetformat.

Equivalent ones:
Vendor         To be changed
A4                   A3
A3                   A3
A2                   A2
A1                   A1
A0                   A0

Note: (We dont use A4 sheetformat)

So is there any macro, which will read the existing drawing sheet format size and replace with our sheet format accordingly?

One more concern is, there are drawings with 2 or more sheets. In this case 1st sheet has one sheetformat and rest of the sheets have another sheetformat. Can the macro be embedded with this feature too?

I do not want to open individual drawing and do this. My requirement is to change sheetformat of all the drawings in a particular folder.

I'm using Solidworks 2016

Sheetformat name:

a0paper.slddrt       (Sheet 1)
a0paper2.slddrt     (If drawings has more than 1 sheet, then use this for 2nd sheet,3rd sheet and so on)
a1paper.slddrt       (Sheet 1)
a1paper2.slddrt     (If drawings has more than 1 sheet, then use this for 2nd sheet,3rd sheet and so on)
a2paper.slddrt       (Sheet 1)
a2paper2.slddrt     (If drawings has more than 1 sheet, then use this for 2nd sheet,3rd sheet and so on)
a3paper.slddrt       (Sheet 1)
a3paper2.slddrt     (If drawings has more than 1 sheet, then use this for 2nd sheet,3rd sheet and so on)

Can someone help me on this with a macro?

Looking for some suggestions.

Thank you in advance.

Regards,
Prasanna.A
Like • Show 0 Likes0
Actions
Elisabeth Daley @ Leon Wurr on Feb 20, 2017 1:54 PM
Mark Correct
Correct Answer
This sounds great, but when I run it, it prints a happy 'success' message, and doesn't actually change any of my files. I've tried it on files in epdm, on my local computer, and then I tried editing the macro so the default paths point where I want it to look (just like it says not to do), all with the same result - no changes. My outdated templates have the same names as the new ones (although they are in a different directory - does this matter?)

Also, when I check the 'And Subfolders' box, it crashes with a run-time error.
Like • Show 0 Likes0
Actions
John Stoltzfus @ Elisabeth Daley on Feb 20, 2017 1:57 PM
Mark Correct
Correct Answer
Leon Wurr hasn't logged in for a long time - use the one I uploaded - that one works
Like • Show 2 Likes2
Actions
Elisabeth Daley @ John Stoltzfus on Feb 20, 2017 3:11 PM
Mark Correct
Correct Answer
Thanks John! This doesn't quite do what I'm looking for - I'm trying to batch replace the formats for a bunch of drawings using templates from a specified folder - not the original one. But maybe I can modify it.
Like • Show 0 Likes0
Actions
Deepak Gupta @ Elisabeth Daley on Feb 20, 2017 3:24 PM
Mark Correct
Correct Answer
You can also try this tool #TASK

Else change the vTemplateName in the macro uploaded by John to your updated sheet format full path and it should work. Change here
Like • Show 2 Likes2
Actions
Elisabeth Daley @ Deepak Gupta on Feb 20, 2017 3:30 PM
Mark Correct
Correct Answer
Thanks!

I was looking at the drawings that need to be updated, and they at least all have the same format names as our current formats, so that should work.

How is #TASK different from TaskScheduler?
Like • Show 1 Like1
Actions
Deepak Gupta @ Elisabeth Daley on Feb 20, 2017 3:37 PM
Mark Correct
Correct Answer
The macro posted above would set the sheet format to none and add that again. So even if same name or different, it would work.

#TASK has lot of inbuilt tools for many repetitive tasks. It has way more tools/options and differs a lot from TaskScheduler. Most of the tools in #TASK are free to use. So do explore that.
Like • Show 2 Likes2
Actions
Elisabeth Daley @ Deepak Gupta on Feb 20, 2017 3:40 PM
Mark Correct
Correct Answer
I understand, it's just that the drawings have different sizes, so I assume I would need to read the existing template name in order to know which size format to map to.

Thanks again, I'll check out #TASK.
Like • Show 0 Likes0
Actions

Need help modifying a "sheet format update" macro

Attachments

Outcomes

Attachments

Attachments

Attachments

Attachments

Attachments

Related Content

Recommended Content

Incoming Links