If you are interested in getting your CSWA or CSWP certification, get on over to SolidWorks' website and check out the Certification Pages. SolidWorks users with Subscription service support may obtain one (1) free exam by using a coupon code. This promotion has been extended until June 3, 2008, and the test must be completed by July 31, 2008.
Good Luck!
Hi sir Lenny...
Have a nice day.Can you help me about my problem??
I have a block that has a cavity in the middle.I want to automatically create a channel in the block using VBA macro..
Please I really need your response..
Looking forward from u Sir Lenny. . .
Posted by: Eng-Blogger | March 18, 2008 at 10:33 PM
Lenny,
My name is Dennis Parr. I am the CAD Administrator for ACRO Automation here in Milwaukee. We down loaded your AssemblyBOM macro and it has saved us a ton of time getting part quantities and releasing parts before the assembly is released, etc. The macro works great! It works so well that we are thinking of implementing it as a way to get BOM data directly from our SolidWorks assemblies into our ERP/MRP system.
We did notice a couple of things I was wondering if there is a way to get them fixed.
(1) Parts in an assembly that have the "Exclude from BOM" option on are still counted in the BOM generated by the macro. Is there a line of code I can add to the macro to get it to treat these parts the same as if though they were suppressed?
(2) In the .ini file I added the [PROPERTY NAMES] for RELEASE DATE and MATERIAL. The release date is a manual input property (user specifies the release date in the file properties of the model for that custom property). The material property in our custom properties in the system variable for material ("SW-Material@Part1.SLDPRT"). Problem is it shows as "SW-Material@Part1.SLDPRT" instead of giving the "evaluated" value of this property (example ALUMINUM). Is there some other way I should assign this value or a line of code for retrieving the information correctly?
I have not done a lot of VB programming, have done some UNIX & VMS script writing so I am not lost when looking at code. If you could point me in the right direction I may be able to muttle my through it. If you could add these enhancements to the macro and required a fee for this service I will see what I can do here. I know your macros are on an "as is" basis, and understand that time is money and no one is in the business of providing a service for free.
Your assistance on this is greatly appreciated.
Thank you,
Dennis F. Parr
CAD Admin / Designer
ACRO Automation Systems, Inc.
2900 W. Green Tree Road
Milwaukee, WI 53209
414-352-4540 x185
Fx: 414-540-5501
EM: dparr@acro.com
Posted by: Dennis Parr | October 16, 2008 at 01:19 PM