Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using this code to create a launch icon on the desktop..
Sub Desktopshortcut() Dim WSHShell As Object Dim MyShortcut As Object Dim DesktopPath As String Set WSHShell = CreateObject("WScript.Shell") DesktopPath = WSHShell.SpecialFolders("Desktop") Set MyShortcut = WSHShell.CreateShortcut(DesktopPath & "\EngstoreSpecial.lnk") With MyShortcut .TargetPath = LocalPathExcelControlSpecial .Save End With Set WSHShell = Nothing End Sub Is it possible to control the symbol so a pre-determined picture icon can be used? |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
With myShortcut
.IconLocation = "x:\somefolder1\somefolder2\someicon.ico" ... Snowfire wrote: I am using this code to create a launch icon on the desktop.. Sub Desktopshortcut() Dim WSHShell As Object Dim MyShortcut As Object Dim DesktopPath As String Set WSHShell = CreateObject("WScript.Shell") DesktopPath = WSHShell.SpecialFolders("Desktop") Set MyShortcut = WSHShell.CreateShortcut(DesktopPath & "\EngstoreSpecial.lnk") With MyShortcut .TargetPath = LocalPathExcelControlSpecial .Save End With Set WSHShell = Nothing End Sub Is it possible to control the symbol so a pre-determined picture icon can be used? -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Yes you can do that, try this
With MyShortcut .TargetPath = LocalPathExcelControlSpecial .IconLocation = "%SystemRoot%\system32\SHELL32.dll, 22" .Save End With Now finding out precisely which is which icon in Shell32.dll is something you'll have to Google for but change the 22 to change to Icon Mike "Snowfire" wrote: I am using this code to create a launch icon on the desktop.. Sub Desktopshortcut() Dim WSHShell As Object Dim MyShortcut As Object Dim DesktopPath As String Set WSHShell = CreateObject("WScript.Shell") DesktopPath = WSHShell.SpecialFolders("Desktop") Set MyShortcut = WSHShell.CreateShortcut(DesktopPath & "\EngstoreSpecial.lnk") With MyShortcut .TargetPath = LocalPathExcelControlSpecial .Save End With Set WSHShell = Nothing End Sub Is it possible to control the symbol so a pre-determined picture icon can be used? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Desktop File Icon | Setting up and Configuration of Excel | |||
Desktop icon name | Excel Programming | |||
Change desktop icon | Excel Programming | |||
how can i put the excel icon on my desktop? | Excel Discussion (Misc queries) | |||
Delete desktop icon with VBA | Excel Programming |