TopSolid'Forum

Hi!
It is possible to import User informations (menu: "file->properties->User informations") from a file to another one?

I did it!
I used a simple program made in vba from excel!!
It works!

Hi.

Can u post the VBA code u use?

Thanks

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

paul-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

Hello
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?