VBA hyperlinks in Excel

[User142523653]

Currently in the middle of an assignment where you have send an excel file as a hyperlink rather than an attachment using VBA, Is there any possible way to do this as at the current moment I am only able to send the location of a link as regular text rather than a hyperlink. Any help would be great appreciated.
Many thanks.

 

[daverunt]

I assume you mean via Outlook?
If so you send it as an HTML mail using .HTMLBody instead of .Body