Variable Problem

[kitty77]

I'm using the following code. How to do I get the value "comps" to appear where test is?
Because it's wrapped in the quotes, I'm getting just the word test. What am I doing wrong?

Dim test As String
If ([Mdid] = "COMP32145") Then test = "comps"
[Mlink] = "#\test\pdf\" & [Mspectraid1] & ".pdf#"
End Sub

 

[MarkK]

Look how you inserted Mspectraid1 into the string. Insert test the same way.

 

[kitty77]

I see it now. Thanks!!