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
Solved

How can I Access the internet from inside Excel vba code

Posted on 2011-02-21
5
242 Views
Last Modified: 2012-05-11
I'd like a button click on my spreadsheet to take the user to my website (www.mywebsite.com). How can I find out which browser the user has installed on his Windows computer and then what commands would I use to call that browser (Internet Explorer or Firefox) and link to my website?
0
Comment
Question by:wcpoa8
  • 3
  • 2
5 Comments
 
LVL 20

Expert Comment

by:darbid73
ID: 34949083
There is a lot of ways to do this with VBA and Internet Explorer, including having a mini webbrowser inside your excel.

Other wise the way you do it is

Application.FollowHyperlink strURL

Open in new window

0
 
LVL 20

Accepted Solution

by:
darbid73 earned 500 total points
ID: 34949087
If you want to read more about it see MSDN Excel 2003 Reference
0
 

Author Comment

by:wcpoa8
ID: 34949131
Does this work in Excel 2007 and 2010?
0
 

Author Comment

by:wcpoa8
ID: 34949146
It seems that it does work in Excel 2007 and 2010.
0
 

Author Closing Comment

by:wcpoa8
ID: 34949148
Thanks!
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

856 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