AnsweredAssumed Answered

Rename sheet in drawing file with multiple custom properties

Question asked by Luca Canderle on Apr 14, 2020
Latest reply on Apr 21, 2020 by Luca Canderle

Like • Show 0 Likes0
Comment • 8

Hi to all

I'm here to ask if someone know a way to rename the sheet in a drawing with multiple custom properties, for sample:

I have an assambly file where A is the code of assembly and A1, A2, A3... are the sub parts of its, I put the assembly file and all sub parts in the same drw file, sheet 1 assembly A, sheet 2 part A1, sheet 3 part A2 ..., now i want rename automaticaly the sheet with the follow custom proprety, code-revision-revision_date.

I found here a macro for rename with only one custom proprety, but I need with multiple custom proprerty

Rename SOLIDWORKS drawing sheets with custom properties values

Can someone helpme?

Thanks

No one else has this question

Outcomes

8 Replies

Artem Taturevych Apr 14, 2020 9:27 PM
Mark Correct
Correct Answer
I've made a slight adjustment to that macro so it is easier to modify it as per your need. Please follow these steps
- Copy the code from the same link (note that I have just changed this so it is important to get the newest code)
- Remove the following lines:
  Dim prpName As String
  prpName = InputBox("Please specify the custom property name to get the value from")
- Modify the following line:
  prpValue = GetCustomPropertyValue(swRefDoc, swRefConfName, prpName)
- And replace it with
- prpValue = GetCustomPropertyValue(swRefDoc, swRefConfName, "code") & "-" & GetCustomPropertyValue(swRefDoc, swRefConfName, "revision") & "-" & GetCustomPropertyValue(swRefDoc, swRefConfName, "revision_date")
Like • Show 0 Likes0
Actions
Luca Canderle Apr 15, 2020 2:55 AM
Mark Correct
Correct Answer
Thanks so much, in the age I try it.
I need to ask another thing, is it possible to start a macro when I save the document? I have some experience with I-Logic module of Inventor, and there you can use save comand or other comand like trigger for run the script.
In the afternoon I updated you if the macro work well.
Thanks
Like • Show 0 Likes0
Actions
- Deepak Gupta @ Luca Canderle on Apr 15, 2020 4:55 AM
  Mark Correct
  Correct Answer
  Luca Canderle wrote:
  
  I need to ask another thing, is it possible to start a macro when I save the document?
  Yes this is possible. Check tis macro here: https://forum.solidworks.com/thread/21658#comment-88655
  Like • Show 1 Like1
  Actions
Artem Taturevych Apr 15, 2020 6:25 AM
Mark Correct
Correct Answer
In addition to Deepak's suggestion here is another tool you can use to run macro on save: MyToolbar - custom macro library manager and another macro: Run VBA macro automatically on document save using SOLIDWORKS API
Like • Show 0 Likes0
Actions
Luca Canderle Apr 16, 2020 5:15 PM
Mark Correct
Correct Answer
I have tried the macro and works well, the sheet take the right name, also I have tried to use it like a task in solidworks epdm, but not work because the file is in check-in and it is close.

Now I try to explain what I need to do.

In my workflow during the transition state to Approved, I have seted increase of revision number, some variables update and at the end some tasks for convesion prt or asm to step and the drw to pdf and dwg. It is my habit to make a drawing with the main assembly in the first sheet with the bom and in the subsequent sheets the sub parts, for sample:
main assembly:    aaa.sldasm
sub parts:             aaa-01, 02, 03....sldprt
the drw file have the same name of the main assembly
in first sheet I insert the    aaa.sldasm
in second sheet I insert    aaa-01
in third sheet I insert         aaa-02
...

Now I would need a macro with follows steps:
1: check-out of selected file
2: open file
3: rename the sheet with custom proprety the you can read in the previsualy message
4: save file
5: check-in file.

Is it possible to make it?
Thanks
Like • Show 0 Likes0
Actions
- Deepak Gupta @ Luca Canderle on Apr 17, 2020 4:38 AM
  Mark Correct
  Correct Answer
  Luca Canderle wrote:
  
  Now I would need a macro with follows steps:
  1: check-out of selected file
  2: open file
  3: rename the sheet with custom proprety the you can read in the previsualy message
  4: save file
  5: check-in file.
  
  Is it possible to make it?
  Thanks
  Yes it is possible but why no do the task before check-in?
  Like • Show 0 Likes0
  Actions
Luca Canderle Apr 17, 2020 5:39 AM
Mark Correct
Correct Answer
Because in epdm for change the state of file, it must be in check-in, I need encrease the revision and after rename the sheets.
Like • Show 0 Likes0
Actions
Luca Canderle Apr 21, 2020 10:32 AM
Mark Correct
Correct Answer
Somebody else?
I will be crazy.
Like • Show 0 Likes0
Actions

Rename sheet in drawing file with multiple custom properties

Outcomes

Related Content

Recommended Content