Solved: Start another application using VBA?

[andrew93]

Hi

I've searched this and the tek-tips forum and am not having much luck. I want to start an application called "ClickYes.exe" using VBA within an Access database but I don't necessarily know which of my users directories it is located in.

The Shell command works ok if I use the full path on my PC, like this :

Shell ("C:\Program Files\ExpressClickYes\ClickYes.exe")

This works fine, but as I said, my users won't necessarily have this application loaded in the same directory.

How can I detect which directory this application is loaded in so I can amend my Shell statement? Or is there another way of starting this application that doesn't involve excessive coding?

TIA, Andrew

{You may ask "Why?" This is part of a much larger process in Access where the user creates a document / report and e-mails a pdf version to their client, and this software temporarily suppresses the outlook alert for automated e-mails. Given this software could be harmful in the wrong hands, I don't want this software running all the time - only when the user needs to use it for sending an e-mail from the database).