Message 1 of 3
Parameters from user form to Embedded excel sheet

Not applicable
04-11-2006
10:21 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
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
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