how can i write from an iam to an embedded excel of an ipt with i-logic

[clemens_wolferstetter]

I would like to write values from the iam to an embedded Excel in an ipt with an I Logic rule. The ipt is integrated in the iam. 

It should work like transferring fx parameters of iam into an ipt with i logic. 

Here is the example for fx paramter. I need the same for "GoExcel.CellValue("3rd Party:Embedding 1", "Sheet1", "A2")"

Sub Main()

Dim Suche As String
Dim zz As Integer	
Dim zDa1 As Double
zDa1=KDa1

'Uebertragung der Werte auf das Bauteil:
		
For zz = 2 To 9 
		
	
		Suche = "-HMP0" + CStr(zz)
		
		
	oDoc=ThisDoc.Document
	Dim oComp As ComponentOccurrence	
	
	For Each oComp In oDoc.ComponentDefinition.Occurrences
		If InStr(oComp.Name, Suche) Then

		oCompName=oComp.Name
 
			
			'Fx-Parameter
			Parameter(oCompName, "Da1") = zDa1
			
	
	Exit For
	End If
	Next

Next	

End Sub

[Cadkunde.nl]

I do the following.

I have user parameters, and fill in the comment "Excel_sheetname_Cell" (for example: Excel_Input_C3)

In my form the done apply/ok buttons are hidden, but I show a button that runs a script.

 Then in my skeleton part i have this script called "Excel Edit"

 It collects all my parameters i wish to bring to excel, then update all parameters and save excel

I add the skeleton part with excel to the assembly (on bom structure reference and visibility off) and name it in the browser #Skeleton

[clemens_wolferstetter]

Hello, thanks for the answer.

I would like to bypass the detour of creating the user parameters. I know the parameter number and how to write it in the cells where I want to have it