Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

MS Access 2003 VBA System Files

Posted on 2013-02-05
2
Medium Priority
?
334 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 2000 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
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…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

610 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