Macro to follow Hyperlink with Ampersand in folder name

[griffj]

Hi

I have created a macro that is set to follow a hyperlink to a folder named, c:\products\Weight&Dimensions. My macro seems to stop at the '&' sign, causing an error as it is looking for a folder called c:\products\Weight.

I can't remove the ampersand, so how can I get Excel to understand that the ampersand is part of the string?

I have tried Replace("c:\products\Weight&Dimensions", "&", Chr(38)) and I have also tried, Replace("c:\products\Weight&Dimensions", "&", ""&"") but these haven't worked.

Any help would be greatly appreciated.

 

[Fluff]

What is your macro?

 

[griffj]

Sub SendEmail()
Amp = Chr(38)
strFileFullName = ThisWorkbook.FullName
ActiveWorkbook.FollowHyperlink Address:="mailto:?subject=Whatever the subject is&Body=" & Replace(strFileFullName, "&", Amp) & ""
End Sub

 

[Fluff]

Neither you're title, nor your explanation mentioned anything about using MailTo.
As it's not something I've ever used, I'm afraid I cannot help.

 

[griffj]

I mentioned I was using a hyperlink. MailTo is just part of the hyperlink.

Thanks for looking.