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