Parameters from user form to Embedded excel sheet

Parameters from user form to Embedded excel sheet

Anonymous
Not applicable
394 Views
2 Replies
Message 1 of 3

Parameters from user form to Embedded excel sheet

Anonymous
Not applicable
Hello All,

I am a new user to this vba customization .

Here is my problem:

Inventor part with a embedded excel sheet driving the major model dimension, I want to use VBA as to facilitate many of conditional inputs which is difficult in Excel.

I want to feed the value from the user form which should update in Excel in turn it should update inventor model. If the excel file is attached with the link option it is easy for me to do ( as I know the location of excel file).

If the same is embedded, am not sure how to do it. I have attached herewith my sample coding done for excel file with the link option for better understanding.

Please help me out....

Best Regards,
Dinesh Babu
0 Likes
395 Views
2 Replies
Replies (2)
Message 2 of 3

Anonymous
Not applicable
Dinesh,

For every excel file that is linked/embedded in the parameters dialog, the
API exposes a ParameterTable object representing all the parameters
contained within that file. You can obtain the collection of all such tables
using:

PartComponentDefinition.Parameters.ParameterTables

And the ParameterTable object supports a WorkSheet property that returns the
excel worksheet. You don't need to distinguish between linked and embedded
tables. The WorkSheet property will return the excel sheet in both cases.

Sanjay-


wrote in message news:5139939@discussion.autodesk.com...
Hello All,

I am a new user to this vba customization .

Here is my problem:

Inventor part with a embedded excel sheet driving the major model dimension,
I want to use VBA as to facilitate many of conditional inputs which is
difficult in Excel.

I want to feed the value from the user form which should update in Excel in
turn it should update inventor model. If the excel file is attached with the
link option it is easy for me to do ( as I know the location of excel
file).=
0

If the same is embedded, am not sure how to do it. I have attached herewith
my sample coding done for excel file with the link option for better
understanding.

Please help me out....

Best Regards,
Dinesh Babu
0 Likes
Message 3 of 3

Anonymous
Not applicable
http://www.mcadforums.com/forums/viewtopic.php?t=5031

My response is why the Excel spreadsheet?
We use VBA forms directly linked to the model parameters, quick and easy.
0 Likes