Grizlore
Active Member
- Joined
- Aug 22, 2006
- Messages
- 259
Hi all,
I am having a stupid day... and can't see why this isn't working...
Simply... why isnt this TRIM() trimming please?
I am having a stupid day... and can't see why this isn't working...
Simply... why isnt this TRIM() trimming please?
Code:
Private Sub CommandButton1_Click()
Dim sapFARM As String
sapFARM = Trim("http://maps.google.co.uk/maps?f=d&source=s_d&saddr=SW1A1AA&daddr=" & txtPostcode.Value)
MsgBox sapFARM ' just to check visually if trimmed
ActiveWorkbook.FollowHyperlink Trim(sapFARM), NewWindow:=True
End Sub