自动创建文件的快捷方式 [英] Automatically create at shortcut to a file

问题描述

我在命令按钮单击下有一小段代码，它将新名称的工作簿文件保存在新位置，我想知道是否还可以在其他位置自动创建该新保存的工作簿的快捷方式位置?

I have a small piece of code under a command button click which saves the workbook file with a new name in a new location, I am wondering if it is possible to also automatically create a shortcut to that newly saved workbook in a different location?

Private Sub CommandButton1_Click()
Dim SelectedFNumber As String
Dim DateStr As String
Dim myFileName As String
Dim StorePath As String

    DateStr = Format(Now, "dd.mm.yy HH.mm")

    SelectedFNumber = Range("B4").Text

    If SelectedFNumber <> "SELECT F NUMBER" And Range("D11") > "0" Then

        StorePath = "G:\Targets\" & SelectedFNumber & "\"

        myFileName = StorePath & SelectedFNumber & " " & DateStr & ".xlsm

        If Len(Dir(StorePath, vbDirectory)) = 0 Then
        MkDir StorePath
        End If

        ActiveWorkbook.SaveAs Filename:=myFileName, FileFormat:=xlOpenXMLWorkbookMacroEnabled
    Else
        MsgBox "Select an F Number"
    End If
End Sub

推荐答案

您基本上需要添加以下内容:

You basically need to add something like this:

Dim sShortcutLocation As String

sShortcutLocation = "C:\blah\workbook shortcut.lnk"

With CreateObject("WScript.Shell").CreateShortcut(sShortcutLocation)
    .TargetPath = myFileName
    .Description = "Shortcut to the file"
     .Save
End With

将位置更改为您想要的任何位置.

changing the location to wherever you want.

这篇关于自动创建文件的快捷方式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！