Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 177
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,718
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Running a macro from windows application Aerojade Excel Discussion (Misc queries) 1 October 3rd 08 01:19 PM
Controlling windows explorer with VB macro gauss1976 Excel Discussion (Misc queries) 0 July 27th 06 09:30 AM
Macro switch between windows question punter Excel Discussion (Misc queries) 3 June 21st 06 06:11 PM
Macro opens two windows banSHF Excel Discussion (Misc queries) 1 September 7th 05 02:14 AM
how do I use scopefolders in excel macro in windows xp mike_cutting-edge[_2_] Excel Programming 2 February 13th 05 07:00 PM


All times are GMT +1. The time now is 02:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"