Hello
I have an intern who is making us an exel macro related to Solidworks (version used: SW premium 2013 x64 Edition - SP 5.0).
The goal is to fill in dimensions and information in this excel table, click on a button and then the desired equipment is modeled in Solidowrks and its drawing is created.
We use title blocks with attributes (name of the designer, date of creation, name of the project, etc...)
I would like the name of the project entered in our excel sheet to appear in the title box in the final drawing.
The program is written in VBA.
Thank you in advance to those who will help us.
Hello
Simply create a custom "Project" property in your MEP template, link the property to the note.
Then by code in the macro, retrieve the value of the cell and put it in the custom property.
1 Like
Hello
For this kind of thing, I used Driveworks Xpress, it allows you to quickly create 3D and the 2D related to it, and it's a tool integrated into solidworks from basic.
Hello Yves T,
"Hello,
Simply create a custom "Project" property in your MEP template, link the property to the note.
Then by code in the macro, retrieve the value of the cell and put it in the custom property."
This is the code part I'm looking for. We have already created the property and linked it to the part of the title block to be filled in. What I'm looking for is the code that tells Solidworks the VBA of my Excel sheet to go and get for the project property the information indicated in my Excel cell.
Thank you in advance.