ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   windows macro (https://www.excelbanter.com/excel-programming/348452-windows-macro.html)

Todd

windows macro
 
Hi,

Is there a site for windows macro's? I want to find or build a macro that
creates a hyperlink to a folder. I have a small macro that builds a set of
folders (5) and I want, even desire, a way to generate a hyperlink to one of
those folders in another folder. The folder that stores all the created links
would not be one of the ones created in the macro but a permanent one.

Is that possible? and where should I go for help.


Thanks,

Todd

Jim Rech

windows macro
 
This macro creates a shortcut to C:\Windows in the C:\a folder named
test.lnk:

Sub MakeFolderShortcut()
Dim wsh As Object
Dim SC As Object
Set wsh = CreateObject("WScript.Shell")
Set SC = wsh.CreateShortcut("c:\a\test.lnk")
SC.TargetPath = "C:\windows"
SC.Save
End Sub


--
Jim
"Todd" wrote in message
...
| Hi,
|
| Is there a site for windows macro's? I want to find or build a macro that
| creates a hyperlink to a folder. I have a small macro that builds a set
of
| folders (5) and I want, even desire, a way to generate a hyperlink to one
of
| those folders in another folder. The folder that stores all the created
links
| would not be one of the ones created in the macro but a permanent one.
|
| Is that possible? and where should I go for help.
|
|
| Thanks,
|
| Todd




All times are GMT +1. The time now is 07:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com