MS Access 2003 VBA System Files

How do I detect the end users default internet explorer.exe file?
It could be on their C or D drive

I have this in my VBA now...
Call Shell("D:\Program Files\Internet Explorer\iexplore.exe " & Me.PathName, vbMaximizedFocus)
Who is Participating?
omgangConnect With a Mentor IT ManagerCommented:
You can use the VBA Environ function to return the value of a Environment Variable.  In your case you could

Dim strDrive As String
Dim strPath As String

strDrive = Environ("ProgramFiles")
strPath = "\Internet Explorer\iexplore.exe "

Call Shell(Chr(34) & strDrive & strPath & Chr(34) & Me.PathName, vbMaximizedFocus)

The Chr(34) replaces the quotation marks need for the shell function (you may not need them - I haven't tested).

OM Gang
lrbristerAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.