View Single Post
  #1   Report Post  
Jim Rech
 
Posts: n/a
Default

You'd need a macro like this:

Sub MakeDesktopShortcut()
Dim wsh As Object
Dim SC As Object
Dim DesktopPath As String
Set wsh = CreateObject("WScript.Shell")
DesktopPath = wsh.SpecialFolders.Item("Desktop")
Set SC = wsh.CreateShortcut(DesktopPath & "\test.lnk")
SC.TargetPath = "C:\book1.xls"
SC.Save
Set wsh = Nothing
End Sub

--
Jim Rech
Excel MVP
"Paul" wrote in message
...
Hi,
To send a shortcut for an excel workbook to my desktop I currently have to
open Explorer, find the file and send it to the desktop.
Is there an easier way in Excel itself?

Thanks for looking

Paul