Execute/Run a Windows Shortcut using VBA

[hkeiner]

How do you execute/run a Windows Shortcut using a VBA command? Below is some information from the Properties window for the Shortcut I am trying to run.

Thanks in advance for any help on this.


General Tab/Location: C:\ZDATABAS\Auto FE Update for Access

Shortcut Tab/Target: "C:\ZDATABAS\Auto FE Update for Access\StartMDB.exe" /cmd /inifile:"C:\ZDATABAS\Auto FE Update for Access\PSAccounting_FE.ini"

Shortcut Tab/Start In: "C:\ZDATABAS\Peoplesoft Accounting\DATABASE-PSAccounting\"

[HiTechCoach]

Try the VBA Shell() function.

Example:

Shell """C:\ZDATABAS\Auto FE Update for Access\StartMDB.exe"" /cmd /inifile:""C:\ZDATABAS\Auto FE Update for Access\PSAccounting_FE.ini""" so

Also see this MSDN article: http://msdn.microsoft.com/en-us/library/office/dd789432%28v=office.12%29.aspx