I'm trying to export a BoM automatically, periodically from an assembly or drawing into an excel file. The BoM will not be present in the drawing so the properties cannot be grabbed straight from a BoM there.

My current plan is as follows: A VBA macro will be able to export a special BoM whose properties and rows/columns are defined by the VBA macro. The Assembly or .dwg file (that the BoM comes from) will be opened by a Visual Basic Express program and the VBA macro will be commanded to run with this same VBE program. The Visual Basic Express program will be run on a timer from task scheduler so that it is run every night and lunchtime.

I have code that will take the assembly's properties and drop them into an excel file. I need the program to grab the part properties as well as the total number of each part in the assembly and drop those in the excel file instead. Also, I need to make a Visual Basic Express program that will find the correct file, open it, and run the VBA macro. I am very new to all of this, so any help or advise would be very much appreciated!! Thanks!

Thomas Brooks