Small correction, alexit - SW only uses VBA. Yes, VB6 and VBA are almost identical, but there are some syntactical differences (for example in the string manipulation area). However, you can use VB, VB.NET, C#, etc. to automate SW or to develop SW add-ins. However, if you want to use the more...
The lack of dynamic update is the biggest problem with the custom table. The only way I have solved it in the past is by converting my code to an add-in that runs whenever someone loads / changes the active window to a drawing.
Evan T. Basalik, MCSD
--------------------------------
It's all...
Typically, when you change dimensions enough, some of the detailing gets out of place. That is the kind of stuff that needs cleaned up.
Evan T. Basalik, MCSD
--------------------------------
It's all about prioritization...
Based on your description, I think it can be done via either automation. The standard drawing templates would work, but would not be able to clean up the drawing. Automation would allow you to set up some rules and then clean up the drawing according to those rules.
Evan T. Basalik, MCSD...
You can use VB or VB.NET. Download the API SDK from SolidWorks.com and install it. That will create a new project type call SW Add-in which will get you jumpstarted.
Evan T. Basalik, MCSD
--------------------------------
It's all about prioritization...
Drawings can typically be very hard to automate b/c the cost/benefit ratio can quickly get out of whack. That being said, it your dimensional changes are pretty small, it can definitely be done. If your VAR cannot do the work, you can always contact TriMech Services (my old employer) - they do...
Are you using VB or VB.NET? If you use VB.NET, you need to make sure you use ReleaseCOMObject to allow .NET to run garbage collection on Excel.
Evan T. Basalik, MCSD
--------------------------------
It's all about prioritization...
Try this format:
Cells(1,1).value
This way, it is very easy to replace the R,C reference with a variable.
Evan T. Basalik, MCSD
--------------------------------
It's all about prioritization...
If your notes refer to the custom properties, then you don't need to get the value of the notes. Just get the values of the custom properties directly using CustomInfo2.
Evan T. Basalik, MCSD
--------------------------------
It's all about prioritization...
You can use the API to do what you want fairly easily.
There is a really good example on doing just that in the API Fundamentals manual.
Evan T. Basalik, MCSD
--------------------------------
It's all about prioritization...
Create a reference to the MS Scripting Runtime (scrrun) and then use the FileSystemObject.
Evan T. Basalik, MCSD
--------------------------------
It's all about prioritization...
moleary,
Exactly what are you trying to extract? I guess I am confused as to what you are trying to do. Could you please give some more details?
Evan T. Basalik, MCSD
--------------------------------
It's all about prioritization...
Could you write your own function by examining the sketch and then looking at common lines?
Evan T. Basalik, MCSD
--------------------------------
It's all about prioritization...
Just change your query that you are using to build your recordset to return the second table instead of the first table.
Evan T. Basalik, MCSD
--------------------------------
It's all about prioritization...
The problem is that PDMWorks does not expose the names of the properties very well. I have used an approach similar to Flatwire's with success in the past. However, I don't think I took ownership of the document to modify stuff.
Evan T. Basalik, MCSD
--------------------------------
It's...