Bonjour,
Petite variante.
Directement en VBS dans un fichier texte que l'on lance depuis VBA :
1 2 3 4 5 6 7 8 9 10 11 12 13 14
| set WshShell = WScript.CreateObject("WScript.Shell" )
strDesktop = WshShell.SpecialFolders("Desktop" )
strCurrentDir = left(WScript.ScriptFullName,(Len(WScript.ScriptFullName))-(len(WScript.ScriptName)))
strAccessDir = WshShell.ExpandEnvironmentStrings("%PROGRAMFILES%") & "\Microsoft Office\Office12\"
set oShellLink = WshShell.CreateShortcut(strDesktop & "\BaseAccess.lnk" )
oShellLink.TargetPath = """" & strAccessDir & "MSACCESS.EXE"""
oShellLink.WindowStyle = 1
oShellLink.IconLocation = strAccessDir & "MSACCESS.EXE, 0"
oShellLink.Description = "Raccourci vers ma base"
oShellLink.WorkingDirectory = strcurrentdir
oShellLink.Arguments = " """ & strcurrentdir & "fichier.accdb"" /wrkgrp """ & strcurrentdir & "prot.mdw"" /user ""admin"" /cmd ""param"""
oShellLink.Save |
Puis on le lance depuis VBA :
Shell Environ("SystemRoot") & "\system32\cscript.exe " & CurrentProject.Path & "\install_raccourci_Access.vbs"
Cordialement,
Partager