How can I create matrix with data

[Anonymous]

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.

[mwighton]

You can refer to an Excel spreadsheet that does your matrix multiplication.

[Anonymous]

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?

[mwighton]

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.