Statistician
MIS
Can anybody help?
I am trying to launch an access database using the shell function in excel VBA. Unfortunately the pathname has spaces in it therefore I am experiencing problems.
Can anyone suggest what I need to do to the following code in order to make it work? :
Dim RetVal As Variant
RetVal = Shell("x:\ACCESS.97\OFFICE\MSACCESS.exe V:\Modelling Analysis\Adhoc Work Requests\Work in Progress\David\overruns.mdb", 3)
Thanks in advance for any assistance!
Dee
I am trying to launch an access database using the shell function in excel VBA. Unfortunately the pathname has spaces in it therefore I am experiencing problems.
Can anyone suggest what I need to do to the following code in order to make it work? :
Dim RetVal As Variant
RetVal = Shell("x:\ACCESS.97\OFFICE\MSACCESS.exe V:\Modelling Analysis\Adhoc Work Requests\Work in Progress\David\overruns.mdb", 3)
Thanks in advance for any assistance!
Dee