VBA to open file path

[tuktuk]

in an access module i use vba to build an excel report, save it on our LAN and then email to a distro list "you report is ready!"

using vba is there a way to add a hyperlink to the LAN location within the email msg?

ideally, i'd like the recieppients to be able to click wiht the emial and have the folder open so that they can view the newly created report.

is this doable?

T

 

[Trevor G]

This snippet of code will open a folder using the shell command

Sub openfolder()
Dim x As Variant
x = Shell("EXPLORER.EXE M:\Access Files\", vbNormalFocus)
End Sub

 

[tuktuk]

gotcha.

how can i trigger the code from an email? does that make sense? i want to be able to open the folder path from the body of an email.


T

 

[Trevor G]

Andrew very kindly wrote a reply to a thread, so take a look to see if it helps.

http://www.mrexcel.com/forum/showpost.php?p=2435236&postcount=13