opening a .mxd using VBA

[ViinodVishwanatha]

Hello guys I am trying to launch ArcGIS through Access (VBA). the code written would find the application that it can use to launch a .mxd file adn then I am using
shell method to launch the intended file.

While my code works fine I am not able to understand as to why my file does not open.

My current code launches a ArcGIS Filehandler to open the file and when I select Use ArcMap or set it to automatic and open in a new application. I see nothing.
Can some one please help me understand the ArcGIS file handler and provide me with a solution to this problem.

Thank you
Vinod

[CarelBodegraven]

Hi Vinod,

We are experiencing the same kind of problem. Your call dates from last year and unluckily no solution was posted since then.

We tried to change the file types (explorer--> option) of MXD and MXT back to ArcMap instead of ArcGIS FileHandler, but that does not seem to do the trick.

Have you found out a solution in the meanwhile?

I would be most grateful if you (or anyone else) could help.

[NeilClemmons]

Been awhile since I've done anything in VBA/VB6 but if I remember right the Shell function doesn't allow you to pass parameters to the executable.  You need to be able to pass the path to the document you want to open.  Use the Windows API function ShellExecute instead.