Opening an mdb from code

[Alan B. Densky]

I want to open an mdb from within another mdb by clicking a button. I guess
that I've got my quotes messed up though, because I can't get it to work:


Dim stAppName As String

' stAppName = "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE
C:\My Documents\Neuro-VISION\SelfGrowthScraper\settings.mdb"

stAppName = "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" & "
" & "C:\My Documents\Neuro-VISION\SelfGrowthScraper\settings.mdb"
Call Shell(stAppName, 1)

Can somebody please straignten me out?

Thanks in advance.

Alan

 

[Douglas J. Steele]

Because of the spaces in path, you need double quotes:

stAppName = """C:\Program Files\Microsoft Office\Office\MSACCESS.EXE""" &
" " & "C:\My Documents\Neuro-VISION\SelfGrowthScraper\settings.mdb"
Call Shell(stAppName, 1)

 

[Alan B.]

Thank you Doug.

Regards,
Alan

Because of the spaces in path, you need double quotes:

stAppName = """C:\Program Files\Microsoft Office\Office\MSACCESS.EXE""" &
" " & "C:\My Documents\Neuro-VISION\SelfGrowthScraper\settings.mdb"
Call Shell(stAppName, 1)