I'm new to the forum, and i hope someone can help me !
I'm currently using Inventor 2012 and i need a macro (code):
I want to know if it's possible to export all the information from the parameters list (everything, names, values, tolerances, comments...) to an excel spreadsheet or a txt file (it can be a table, or a CVS file, i just want that information!), from a part file (.ipt) or a drawing file (.dwg).
Currently, i can only export the parameters' names and values , but i can't get to the tolerance values and comments . . .
Is there anyway to do this ?
I attach an IVB file that you can use to export parameter properties to excel, you can modify it to export any other properties you want.
Hope it helps.
Thank you for your reply, but when i try to run the macro, an error message shows up:
" Compile Error: can't find project or libray." :\
How do i solve this ?
Can you tell which line the error occurs? And have you Excel 2010 installed on your machine, or a different version? If you have a different Excel version installed, then please change the reference to that Object Library:
1. Load the IVB into VBA Editor.
2. Click Tools->References.
3. In the References dialog find the "Microsoft Excel *.0 Object Library", the '*' indicates the version number that you have.
Please let me if this solves.
The error occurs in line 10 ("Dim oExcel As Excel.Application"), but line 1 turns yellow ("Sub ExpoertParamToText()")
I currently have M.Office Excel 2007, and on Tools > References , I have a "MISSING: Microsoft Excel 14.0 Object Library" checked... Is it supposed to be that way ?
Thank you for your help so far!
Sorry for late response. I added the reference to Excel 2010(Microsoft Excel 14.0 Object Library) in the IVB file, if you have the Excel 2007 then you have to modify the reference to your version.
Thank you so much for your help, i was able to do it !
I just needed one more thing: is it possible to export the tolerance information? For example:
- if i have a hole in a part, and i set the deviation tolerance, with maximum and minimum values, can i export these ?
- or if i set a H7 tolerance for a hole (or a shaft), can i export these too ?
Once again, thank you!
Yes, sure you can. You can get the Upper, Lower, HoleTolerance and ShaftTolerance from Parameter.Tolerance object. You can firstly check what tolerance type the parameter is set, and then export the tolerance values you want.
In order to do that, do i have to change/edit the code?
Wich lines do i have to edit (or add) and in wich section of the code ?
Can you help me do that ?
Thank you so much, you really helped me and my project !
Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register