?
Solved

MS Access 2003 VBA System Files

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

What Is Blockchain Technology?

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
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…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

765 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