View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
steve steve is offline
external usenet poster
 
Posts: 141
Default send attachment using file path from hyperlink

Hi,


I have some code that send an email attachment like

..Attachments.Add ("Path/filename")

instead I would like to use a hyperlink to get the text
string from, like

..Attachments.Add Cells(1, 2)

(which of course doesn't work)

where B1 would have a hyperlink with the path and
filename.

So I would like replace the ("Path/filename")
with the text string of the hyperlink in B1


Thanks,

Steve