- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
How can I create matrix with data
Hi,
I hope anyone can help me.
I use Inventor and VBA for Applications. A am new in VBA, but I have made a simple code through it I manipulate assembly model's parameters.
Everything was OK until I realized that I have to use matrix multiplications to figure out some parameters.
I understood that I can not make matrix multiplication without API objects.
But I stuck and I need a little help.
The problem is that I have to create two 3x3 matrix and I have to put specific date with them. After that I have to multiply them.
Can anyone to propose me simple code about this problem.
Thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
If so please use the 'Accept as Solution' or 'Kudos' Button below.
God Bless
Mwighton
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
But can the VBA code to be connected at the same time with Inventor and with Excel.
Because I use ForLoop code to send new parameters to Inventor for every step.
And for every step I have to have new matrix multiplication results.
Is this possible?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
This link has info about read/write to excel.
It is possible to write to an excel sheet and pull from it.
I am not an expert on VB coding so I cant help you directly, but there are multiple sources on the forum for excel interactions with inventor and VB.
If so please use the 'Accept as Solution' or 'Kudos' Button below.
God Bless
Mwighton