CAD Forum

Jacomuller

Thanks for the feedback - I have been programming in VB6 for many years - I am very old school.

I will put this one in the "too hard basket" for now. I am a Mechanical engineer doing some programming for fun. Thanks again for your time.

Jacomuller

jcapriotti SPerman , I have done a number of VBA macro's for Solidworks. For example, I have a macro that will with a click of the button, create a PDF file as well as a DXF file of a drawing. It will then save those files in the PDM, delete copies of old versions on the those files on the factory ...

Jacomuller

Thanks @jcapriotti , lazy me

. I was hoping for a bit of code to transition a list of part through 5 states with the click of a button. No worries, I will do it the hard way then.

Jacomuller

We have hundreds of parts and assemblies in a certain workflow state. I am the PDM administrator and I want to change the workflow state of all those parts with a VBA macro. I did some google searches but couldn't find any sample code. Si there anybody with some ideas how to do this? Most of the par...

Jacomuller

Thanks @gupta9665 . It is now working fine.

Jacomuller

Hi @RonE

Do you have some wisdom about this issue? It should be very similar to the problem you solved earlier - I am just not skilled enough to connect the dots.

Regards

Jaco

Jacomuller

Hi @RonE

Thanks, it did the job. I am a self taught VBA programmer. Hopefully I will get better at it soon

. I just need more reference material about the API

Regards
Jaco

Jacomuller

Hi RonE Thanks for the message. I saw that before but I cannot get it to work. I have actually tried ChatGPT to help :D but I still cannot get it going. This is the code I got from ChatGPT: Sub SetPartConfigurationGrouping() Dim swApp As SldWorks.SldWorks Dim swModel As ModelDoc2 Dim swAssembly As A...

Jacomuller

I am using VBA code to automatically generate shop floor papers. As part of the process I create a Bill of Material Table to list all parts for an assembly. I have one part used in two different sub assemblies of the main assembly. The problem now is that this parts with the same part number, descri...

Jacomuller

In a similar case, how do I set "Display all configuration of the same part as one item" as "Part configuration Grouping" with VBA code?

Jacomuller

#SPerman - I have tried it before and it use to work, but for some reason it is not working now. This is my code: Option Explicit Dim swApp As SldWorks.SldWorks Dim swModel As SldWorks.ModelDoc2 Dim swDraw As SldWorks.DrawingDoc Dim swSheet As Sheet Dim SelMan As SldWorks.SelectionMgr Dim retval As ...

Jacomuller

G'Day I use a macro to insert a new custom size sheet in a Solidworks 2019 drawing. (I have created a custom template "TAG_MW_Single_View".) The macro work well and it sets all properties as required. The only thing missing is to deselect "Display sheet format". I have recorded m...

Jacomuller

SPerman wrote: ↑Fri Aug 02, 2024 7:04 am See if this helps.

https://help.solidworks.com/2018/englis ... ple_VB.htm

Thanks, I got enough info from that sample to get my code to past the new view where I want it. Thanks again

Jacomuller

I suppose there are many ways to skin a cat

. For the time being I will stick with what we are doing.

this is just an example of a treehouse

Jacomuller

I have now manage to get the macro running to open a specific drawing, activate a specific sheet and copy a selected view, close the drawing and paste the selection in the current drawing. The issue now is that the new drawing view is not pasted in the correct position. Earlier in the Macro, I creat...

Jacomuller

I am wondering if there is a better way of handling processes to parts in Solidworks. For the bulk of it, we only have a part number for the finished part in the solidworks model. For example: We laser cut a profile out of 10mm plate. We then bend the plate to form a "Bend Part", we then p...

Jacomuller

Maybe my approach was wrong. I have written the macro to create predefined views which I was hoping to be able to be updated with a view from a part drawing. Since I have the name of the drawing, the full path of the drawing file and the the name of the view, Maybe I should have tried to copy the re...

Jacomuller

I want to automate one of our shop floor papers. We have a 1 page document with a drawing of an assembly in the top left. I want the macro to list all the parts with some detail from the custom properties of each part. There must also be a single view drawing with some production related information...

Jacomuller

Hi JSculley . thanks again for your input. I got the "clean-up" working so all unused views will be deleted at the end of the macro. I couldn't get the resizing of the views/text to work but that is ok. The next step is to copy a view from one drawing to a specific view in this drawing. I ...

Jacomuller

Good Morning JSculley . I fiddled a bit with the code and it is working fine, thanks again for your help UU . It still continuously working on making it better. Is there a way I can set the "wordwrap width" with the code? Keep in mind that I don't have "SOLIDWORKS Document Manager API...

Jacomuller

I have a create a macro to add 15 empty views to a drawing. Each view represent a part from a BOM for an assembly. This is for our production team on the shop floor. I have created an array text strings, build-up from a number of Custom properties of each parts. I now want to add a text string to ea...

Jacomuller

Thanks JSculley , was thinking about that, but not sure how to implement it. Normally you would know the total number of actions/events and then show the percentage completed on the status bar. In this case, I want to delete all instances of a file outside the PDM on a network drive and replace it w...

Jacomuller

I wrote a macro to delete and copy a file on a number of different net work drive locations. This can take up to 45 seconds in which time I don't want the user to fiddle around clicking other stuff. So the idea is to change the mouse pointer to an hourglass at the start of the macro and then to retu...

Jacomuller

Thanks @AlexB , I had a typo in the way I construct the file path. it is now working fine.

Jacomuller

My code for testing to delete a file from the PDM is:

there is a "run-time error 91" at the line starting with "Set Myfile.."

Am I missing something in the code?

Jacomuller

AlexB thanks. I saw that one yesterday. It is a very handy utility. I will grab the parts I need from the VB and use that in my VBA macro. My macro does a lot of things of which the "delete the PDF in the PDM" is just a small part. I suppose I was lazy and looking for a quick fix :) . I w...

Jacomuller

I am trying to delete a file from the PDM but it is not working for me. This is the code I have: ' DeleteFile = sPathName & DeleteFileFilter ' sFileName 'DeleteFileFilter ' If Dir(DeleteFile) <> "" Then ' 'MsgBox "This File Exists" ' If Len(Dir(DeleteFile)) > 0 Then ' SetAttr...

Jacomuller

@ryan-feeley Thanks mate

I had to massage it a little but it appears to be working now. I still need to cleanup the code a bit, but I am getting the the transformed values now in the CSV file.

Jacomuller

SPerman Yip, I have done it that way a few times. I was just thinking of making it easier for other people in the team. Also, by doing it the way I want, I can leave the original part modeled from the scan data and move the coordinate system to suite the Bender. If, for what ever reason, the bender...

Jacomuller

Thanks SPerman , ryan-feeley . I saw those websites but I still struggling :? :lol: So I have a 3D sketch for the center line of the exhaust pipe. I have a number of points in the 3D sketch required for the bender. I have created the "New" coordinate system in a location that will work wit...

Jacomuller

I want to use scan data from a exhaust pipe to create a bend table for our bender. It uses XYZ and not LRA coordinate system. I can postprocess the scan data to generate a center line based on lines and arcs. I have also create a macro that will generate a CSV file with the XYZ coordinates of each p...

Jacomuller

I have done the "loop through all folders and subfolder" thing and it works - it is a bit slow, but will do for now - a lot faster than manual and no errors

. There are about 3500 folders and 9000 files to check and it is done in about 5 sec. So it is all good.

Jacomuller

bnemec Thanks for the reply. We have our product specific components and then we have generic parts. The generic part numbers start with 000- , so it is easy to separate. The issue is with parts that are not generic, but is used in two or three (max 6) other products. We have about 800 products wit...

Jacomuller

We have a small engineering department using Solidworks and PDM. The factory is in a separate building and does not have access to the PDM. We have a folder system on the network with folders for each product. We then have a subfolder for DXF files and a subfolder for PDF drawings. I have created a ...

Jacomuller

Hi josh , I have tried to use the same technique as what you have done, but I am struggling. If it was in the VB editor, it would have been a bit easier (Since I don't code that often :D ) but doing in the custom properties field is challenging. In essence, what I want to do is the following (writte...

Jacomuller

I have added two lines of to skip sub-assemblies as I am only interested in individual parts. 1 Dim vComps As Variant Dim Cnt As Long Dim i As Long vComps = Assembly.GetComponents(False) For i = 0 To UBound(vComps) If vComps(i).GetSuppression2 <> 0 Then If vComps(i).GetModelDoc2.GetType = swDocPART ...

Jacomuller

Yip, will have a new look at it with that in mind, thanks.

Jacomuller

Awesome Thanks @zwei

Jacomuller

I want to create a custom property for an assembly to show the number of parts in the assembly. Basically I want to

Link this to a custom property.

Jacomuller

Finally - Thanks to @bnemec I have solved the issue. I had Admin in all the groups and the group policy prevented the "check out by other user" to be check-in.

Jacomuller

This is a screen shot of the "Undo check out". I was expecting a warning that the file is checked out on another computer by another user, but that it will still allow me to undo the check out

Jacomuller

I have tried both as "Admin" as well as on my account. Both just give me the same screen. It is the same whether I have the "Can undo check out files checked out by other users" selected or not selected. I normally set at group level, not user level.

Jacomuller

Dwight . Thanks for the feedback. I would prefer to have the data in the Assembly's custom properties as I am using another macro to populated data for the ERP from the Assembly's custom properties. bnemec The "ZPaint" part is actually a spray gun that is visible in BOM drawing. In the BO...

Jacomuller

One of the Pc's in the office died and there were a few files checked out by another user. I have admin rights, but for some reason can I not get the undo check out to work. I use SW2019 with PDM professional. I have done the required permissions etc. but it is not working.

Jacomuller

Thanks, I will do it manually then

Jacomuller

Thanks, I will have a look at it when your done

Jacomuller

I have tried the method recommended by @CarrieIves, but it still the "discontinued" part can still be selected by the designers. Not sure if I did something wrong. I was hoping that all existing assemblies with the discontinued parts will still work as before, but designers should not be a...

Jacomuller

The way we address "paint" in our assemblies (mainly for EPR and BOM purposes) is to have a "dummy" part called ZPAINT in all assemblies. This dummy part has many configuration indicating the paint or powder coat process, the colour and the texture. I want the a custom property c...

Jacomuller

We have about 800 assemblies in our PDM. Most of these assemblies use some generic parts. From time to time we update these generic parts. The challenge is to to keep the older generic parts in the PDM and keep using it in older designed assemblies, but to prevent designers to use these parts in new...

Jacomuller

Thanks, I missed your answer before - got side tracked

I can use parts of it but it will still need a few major steps.

Search found 51 matches