iAssembly Spreadsheet auto Update

iAssembly Spreadsheet auto Update

Anonymous
Not applicable
521 Views
3 Replies
Message 1 of 4

iAssembly Spreadsheet auto Update

Anonymous
Not applicable

Is there any way to edit the table ("Edit via spreadsheet") when I open the iAssembly? I have called some Parameters from Base part which drives the assembly. When the Base part Parameters change, it will take effect only if I open the iAssembly Excel ("Edit via spreadsheet") as I have used some excel formulae there. My requirement is just to open, Save and Close the Excel.

0 Likes
522 Views
3 Replies
Replies (3)
Message 2 of 4

machiel.veldkamp
Collaborator
Collaborator

Maybe this can help you

 

http://beinginventive.typepad.com/being-inventive/ipartiassemblyexcel/

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

___________________________
0 Likes
Message 3 of 4

Anonymous
Not applicable

Hi,

To clarify my need further I've attached an image. When the assembly is opened, the iLogic should automatically trigger the task(Open, Save & Close) what I need to do manually now.

0 Likes
Message 4 of 4

Anonymous
Not applicable

Hi,

 

I've made an iAssy which is being driven by another file called Parameters.xlsx. If I do any update in Parameters.xlsx, it will update the main iAssy table. but  to get the iAssy updated we need to open the excel via "Edit via Spreadsheet" option to save (the updates done in Parameters.xlsx) & Close. my requirement is to automate the "Edit via Spreadsheet" option to open,Save & Close.

0 Likes