Open ArcMap from a button in GIS

[www]

Hi,

I am trying to use a button in Access to open a GIS map, but this is new to me. My code is:



Private Sub Command48_Click()
Shell "ArcMap.exe J:\GISProjects\Irrigated Lands\SpecialProjects\18_GrowerParticipation\onfar mtest.mxd", vbNormalFocus
End Sub

When I use the button, I get an error "Run-time error '53': File not found" Any help sorting this out would be appreciated.

[ranman256]

give the FULL path to ArcMap

call shell ("c:\program files\ArcMap.exe J:\GISProjects\Irrigated Lands\SpecialProjects\18_GrowerParticipation\onfar mtest.mxd", vbNormalFocus)

[kd2017]

You need quotes around your filename because there are spaces in it. Also it may not hurt to use the full path to the ArcMap.exe, if it has spaces in the path then put it in quotes too.

Shell "ArcMap.exe ""J:\GISProjects\Irrigated Lands\SpecialProjects\18_GrowerParticipation\onfar mtest.mxd""", vbNormalFocus

[www]

Thank you, I combined both suggestions and got it to work.

Thanks again.