Carry a variable in memory (substitute)

[tractng]

Guys,

Its been years I have touch VB/VBA.

How do i carry a variable in memory. I need to put the value of Myvalue on this line below. I recall something about using the % or &, but its been too long time ago.


oPropsets2.Add "'%Myvalue%'", "Category", 2

Thanks,
Tony

----------------------------
Dim Myvalue As Variant

Myvalue = "1234"

'Dim oUserProps As PropertySet
Set oPropsets2 = oDoc1.PropertySets("{D5CDD505-2E9C-101B-9397-08002B2CF9AE}")
oPropsets2.Add "'%Myvalue%'", "Category", 2

 

[PHV]

Why not simply this ?
oPropsets2.Add Myvalue, "Category", 2

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[tractng]

Thanks so much.

Tony