Make shortcut to Excelfile on desktop
You can create a subroutine that would send a shortcut to
"G:\Temp\Temp2\Test2.xls to your desktop. However, if you're always going
to be sending the same shortcut to the desktop, it seems it would be quicker
to manually create the shortcut than it would be to write the subroutine or
do you really want to accumulate many duplicate shortcuts to Test2.xls on
your desktop?
Steve
"excelent" wrote in message
...
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
|