[Mlink] = "#\comps\pdf\" & [Msample] & ".pdf#"
Msample data looks like this: 12345.SPA, so the above results is: \comps\pdf\12345.SPA.pdf
How can I remove the .SPA? So it looks like \comps\pdf\12345.pdf in vba.
Msample data looks like this: 12345.SPA, so the above results is: \comps\pdf\12345.SPA.pdf
How can I remove the .SPA? So it looks like \comps\pdf\12345.pdf in vba.