how to write override massproperties using macro data from excel

how to write override massproperties using macro data from excel

lohithna
Enthusiast Enthusiast
536 Views
4 Replies
Message 1 of 5

how to write override massproperties using macro data from excel

lohithna
Enthusiast
Enthusiast

i need to overide the set mass properties in excel file or folder , please help with micro 

0 Likes
537 Views
4 Replies
Replies (4)
Message 2 of 5

mcgyvr
Consultant
Consultant

@lohithna wrote:

i need to overide the set mass properties in excel file or folder , please help with micro 


You need to be way more specific than that.. 

 

If English is not your native language and thats preventing you from providing sufficient details then please write in your native language and we can use Google translate to attempt to understand what you are asking..



-------------------------------------------------------------------------------------------
Inventor 2023 - Dell Precision 5570

Did you find this reply helpful ? If so please use the Accept Solution button below.
Maybe buy me a beer through Venmo @mcgyvr1269
Message 3 of 5

lohithna
Enthusiast
Enthusiast

in inventor property colum , there is predefined mass properties . but as per my requirement i need to over ride the mass properties using macro .

data will avialble in excel . by entering inpeut folder link in excel and pressing a button this mass properties as to write as per excel data 

 

mass.JPG

kelly.young has embedded your image for clarity.

0 Likes
Message 4 of 5

lohithna
Enthusiast
Enthusiast

any one help on my requirment  

0 Likes
Message 5 of 5

MechMachineMan
Advisor
Advisor

HI @lohithna

 

Please attempt solving the problem using the available resources online and post back if you have issues.

 

There are many guides and blogs out there regarding iLogic and accessing excel using the GoExcel commands.

 

You should simply be able to use the go excel commands to find the relevant row/field and then write them to the Mass Iproperty - also using the appropriate iLogic commands.

 

Simplying googling "Autodesk + iLogic + GoExcel" should yield many results.


--------------------------------------
Did you find this reply helpful ? If so please use the 'Accept as Solution' or 'Like' button below.

Justin K
Inventor 2018.2.3, Build 227 | Excel 2013+ VBA
ERP/CAD Communication | Custom Scripting
Machine Design | Process Optimization


iLogic/Inventor API: Autodesk Online Help | API Shortcut In Google Chrome | iLogic API Documentation
Vb.Net/VBA Programming: MSDN | Stackoverflow | Excel Object Model
Inventor API/VBA/Vb.Net Learning Resources: Forum Thread

Sample Solutions:Debugging in iLogic ( and Batch PDF Export Sample ) | API HasSaveCopyAs Issues |
BOM Export & Column Reorder | Reorient Skewed Part | Add Internal Profile Dogbones |
Run iLogic From VBA | Batch File Renaming| Continuous Pick/Rename Objects

Local Help: %PUBLIC%\Documents\Autodesk\Inventor 2018\Local Help

Ideas: Dockable/Customizable Property Browser | Section Line API/Thread Feature in Assembly/PartsList API Static Cells | Fourth BOM Type
0 Likes