Is it possible to tell if a workbook has been opened from an email attachment, rather than a drive/share?
+1
A:
From outlook files are opened to a temp dir on your drive, you could check to see if its in that folder, VBA Source as follows
IsAttachment = (InStr(1, ThisWorkbook.Path, "Temporary Internet Files", vbTextCompare) > 0)
almog.ori
2009-10-27 12:27:33
I agree. There isn't a "source" property. The only way you could guess, is by looking at the path.
Christian Payne
2009-10-28 00:05:39
Thank you for your help with this.
derek b
2009-10-30 09:48:22
Anytime :) ...........
almog.ori
2009-10-30 10:07:04