ACCESS 中如何用 WSH 创建桌面快捷方式

最新推荐文章于 2021-07-18 00:36:59 发布

changechange

最新推荐文章于 2021-07-18 00:36:59 发布

阅读量1.9k

点赞数

分类专栏：特有函数以及自定义函数、过程发布、打包、应用项目文章标签： access templates fonts vba function windows

本文链接：https://blog.csdn.net/changechange/article/details/495900

版权

特有函数以及自定义函数、过程同时被 2 个专栏收录

6 篇文章 0 订阅

订阅专栏

发布、打包、应用项目

3 篇文章 0 订阅

订阅专栏

如何用 WSH 创建桌面快捷方式

需要 WINDOWS 支持 WSH

Public Sub CreatShortcut_desktop()
'请先引用 Windows Script Host Object Model

    Dim strDesktop As String
    Dim strPrograms As String
    Dim wsh As New WshShell
    Dim objShellLink As WshShortcut
    Dim strAppPath As String

    strAppPath = SysCmd(acSysCmdAccessDir)
    strDesktop = wsh.SpecialFolders("Desktop")
    Set objShellLink = wsh.CreateShortcut(strDesktop & "/access911.lnk")
    objShellLink.TargetPath = strAppPath & "msaccess.exe"
    objShellLink.Arguments = """c:/a.mde"" /excl"
    '注意以上两行的写法，上述是用 EXE 去打开某个文件，MDB 文件名对
    '快捷方式来说只是一个命令行参数，而不是快捷方式目标的本身。
    objShellLink.IconLocation = strAppPath & "msaccess.exe,10"
    objShellLink.Description = "某个 mdb 文件"
    objShellLink.WorkingDirectory = strDesktop
    objShellLink.Save

End Sub

SpecialFolders 对象还有以下参数可选，请各位自己按英文的字面意思去理解：

AllUsersDesktop
AllUsersStartMenu
AllUsersPrograms
AllUsersStartup
Desktop
Favorites
Fonts
MyDocuments
NetHood
PrintHood
Programs
Recent
SendTo
StartMenu
Startup
Templates

可支持 WSH 的操作系统，以及支持的版本号：
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/wsversion.asp

Windows?Script?Host

WSH Version Information

The following table lists the version of Windows Script Host
Host Application                      1       2       5.6
Microsoft Windows 98                  x
Microsoft Windows NT 4 Option Pack    x
Microsoft Windows 2000                        X
Microsoft Windows XP                                  X

The following table lists Windows Script Host language eleme
Language Element                      1       2       5.6
<?job ?> Element                              X
<?XML ?> Element                              X
AddPrinterConnection Method           x
AddWindowsPrinterConnection Method            X
AppActivate Method                            X
Arguments Property                    x
AtEndOfLine Property                          X
AtEndOfStream Property                        X
Character Property                                    x
Close Method                                  X
Column Property                               X
ComputerName Property                 x
ConnectObject Method                          x
Count Method                          x
CreateObject Method                   x
CreateScript Method                                   x
CreateShortcut Method                 x
Description Property                  x
Description Property (WshRemote)                      x
DisconnectObject Method               x
Echo Method                           x
EnumNetworkDrives Method              x
EnumPrinterConnections Method         x
Environment Property                  x
Error Property (WshRemote)                            x
<example> Element                                     x
Exec Method                                           x
Execute Method                                        x
Exists Method                                         x
ExitCode Property                                     x
ExpandEnvironmentStrings Method       x
FullName Property                     x
GetObject Method                      x
GetResource Method                            x
HotKey Property                       x
IconLocation Property                 x
Item Property                         x
Item Property (WshNamed)                              x
Item Property (WshUnnamed)                            x
<job> Element                                 x       x
Length Property                       x
Line Property                                 x
Line Property (WshRemote)                             x
LogEvent Method                               x
MapNetworkDrive Method                x
Name Property                         x
<named> Element                                       x
Number Property                                       x
<object> Element                              x
<package> Element                             x
Path Property                         x
Popup Method                          x
ProcessID Property                                    x
Quit Method                           x
Read Method                                   x
ReadAll Method                                x
ReadLine Method                               x
<reference> Element                           x
RegDelete Method                      x
RegRead Method                        x
RegWrite Method                       x
Remove Method                         x
RemoveNetworkDrive Method             x
RemovePrinterConnection Method        x
<resource> Element
Run Method                            x
<runtime> Element                                     x
Save Method                           x
<script> Element                              x
ScriptFullName Property               x
ScriptName Property                   x
SendKeys Method                               x
SetDefaultPrinter Method              x
ShowUsage Method                                      x
Skip Method                                   x
SkipLine Method                               x
Sleep Method                                  x
Source Property                                       x
SourceText Property                                   x
SpecialFolders Property               x
Status Property (WshRemote)                           x
Status Property (WshScriptExec)                       x
StdErr Property                               x
StdErr Property (WshScriptExec)                       x
StdIn Property                                x
StdIn Property (WshScriptExec)                        x
StdOut Property                               x
StdOut Property (WshScriptExec)                       x
TargetPath Property                   x
Terminate Method (WshScriptExec)                      x
<usage> Element                                       x
UserDomain Property                   x
UserName Property                     x
Version Property                      x
WindowStyle Property                  x
WorkingDirectory Property             x
Write Method                                  x
WriteBlankLines Method                        x
WriteLine Method                              x
WScript Object                        x
WshArguments Object                   x
WshController Object                                  x
WshEnvironment Object                 x
WshNamed Object                                       x
WshNetwork Object                     x
WshRemote Object                                      x
WshRemoteError Object                                 x
WshScriptExec Object                                  x
WshShell Object                       x
WshShortcut Object                    x
WshSpecialFolders Object              x
WshUnnamed Object                                     x
WshUrlShortcut Object                 x