View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
excelent excelent is offline
external usenet poster
 
Posts: 695
Default Make shortcut to Excelfile on desktop

Hi all

I got a Workbook Test.xls
in cell B2 i have a hyperlink to G:\Temp\Temp2

When i click on that link, the map with files popup
Then rightclick on file Test2.xls and select send to
deskto as shortcut

Hav can i make that happens automatic with a macro
so when i click on the link, the shortcut to Test2.xls
is send to desktop ?

Thanks in advance