Solved

MS Access 2003 VBA System Files

Posted on 2013-02-05
2
327 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 28

Accepted Solution

by:
omgang earned 500 total points
ID: 38856431
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
ID: 38869254
Thanks
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

737 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