Alhakeem1977
Registered User.
- Local time
- Tomorrow, 00:11
- Joined
- Jun 24, 2017
- Messages
- 308
Hi,
How can I make the Desktop shortcut for Front End file target folder as a dynamic path?
Like there are some users they don't have a 'D' Drive they have 'F' instead.
The below VBA code specifying the D Drive is the target folder how can I make it dynamic?
Thanks in advance!
How can I make the Desktop shortcut for Front End file target folder as a dynamic path?
Like there are some users they don't have a 'D' Drive they have 'F' instead.
The below VBA code specifying the D Drive is the target folder how can I make it dynamic?
Code:
FileName = "MyShortcut"
Set oShell = CreateObject("WScript.Shell")
Set Shortcut = oShell.CreateShortcut(oShell.SpecialFolders("Desktop") & "\DMS_Doc. Register.lnk")
Shortcut.Description = "My shortcut"
[COLOR="Red"]Shortcut.TargetPath = "D:\Document Dispatch Register.accdb"[/COLOR]
Shortcut.WindowStyle = 1
Shortcut.Hotkey = ""
Shortcut.IconLocation = "A:\Databases\ProgramFile\Doc.ico, 0"
Shortcut.Save
Thanks in advance!
Last edited: