Hi!
It is possible to import User informations (menu: "file->properties->User informations") from a file to another one?
User informations
Moderators: remi77, jacs, Daniel
In a TopSolid document you create User properties with a specific names, for example $NAME, $QUANTITY... and so on.
Then you write in Excel cells A1, A2 the values you want to copy.
The TopSolid document has to be open, then you run this Macro:
Sub Micos3()
Dim topapp As TopSolid.Application
Dim topdoc As TopSolid.Document
Set topapp = New TopSolid.Application
Set topdoc = topapp.ActiveDocument
topdoc.SetProperty "$NAME", Range(A & "1").Value
topdoc.SetProperty "$QUANTITY", Range(A & "2").Value
...
end sub
Then you write in Excel cells A1, A2 the values you want to copy.
The TopSolid document has to be open, then you run this Macro:
Sub Micos3()
Dim topapp As TopSolid.Application
Dim topdoc As TopSolid.Document
Set topapp = New TopSolid.Application
Set topdoc = topapp.ActiveDocument
topdoc.SetProperty "$NAME", Range(A & "1").Value
topdoc.SetProperty "$QUANTITY", Range(A & "2").Value
...
end sub
Hellopaul-ince wrote:In a TopSolid document you create User properties with a specific names, for example $NAME, $QUANTITY... and so on.
Then you write in Excel cells A1, A2 the values you want to copy.
The TopSolid document has to be open, then you run this Macro:
Sub Micos3()
Dim topapp As TopSolid.Application
Dim topdoc As TopSolid.Document
Set topapp = New TopSolid.Application
Set topdoc = topapp.ActiveDocument
topdoc.SetProperty "$NAME", Range(A & "1").Value
topdoc.SetProperty "$QUANTITY", Range(A & "2").Value
...
end sub
1.I wrote values to macro in excel.
2.I opend setting plan in TS and I wrote value $TOM to cell
3.In Excel has had value in cell: TYP
How is next step?