Add %20 to file path with spaces using Application.ThisWorkbook.FullName

[jackson1990]

Hey everyone!

Was wondering if there was a way to get Application.ThisWorkbook.FullName to display spaces as %20? I am having an outlook email pop up and in the body it is making a link to the file. If the file has spaces in it though the link ceases to work correctly. I've read if you use %20 for between spaces it should fill the gaps (literally) correctly. I was wondering if it is possible to get Application.ThisWorkbook.FullName to display it this way?

Thanks!

 

[shg]

replace(thisworkbook.fullname, " ", "%20")

 

[jackson1990]

This worked like a charm. So simple don't know why I couldn't think of it. Thank you shg!