Solved

MS Access 2003 VBA System Files

Posted on 2013-02-05
2
318 Views
Last Modified: 2013-02-08
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)
0
Comment
Question by:lrbrister
2 Comments
 
LVL 28

Accepted Solution

by:
omgang earned 500 total points
Comment Utility
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
0
 

Author Closing Comment

by:lrbrister
Comment Utility
Thanks
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now