Getting a webpage embedded in Excel

[JWahlin]

Hi,
I am trying to add a map from a webpage to my excel sheet. On the web page itself there is a guide on how to add their maps to your own webpage using a java script. Now i wonder if it is possible that by using this script add the map to an excel sheet instead.

This is how the instructions read

"Put a Live map of your area in your web site
If you wish, you may put a part of our map that covers your area in your own web site. It is very easy to do this by inserting the following code line into the HTML of your web page, at the point where the map will be displayed:


******** type="text/javascript">
width='80%'; //the width of the embedded map in pixels or percentage
height=400; //the height of the embedded map in pixels or percentage
border=1; //the width of border around the map. Zero means no border
notation=false; //true or false to display or not the vessel icons and options at the left
shownames=false; //true or false to dispaly ship names on the map
latitude=37.4460; //the latitude of the center of the map in decimal degrees
longitude=24.9467; //the longitude of the center of the map in decimal degrees
zoom=9; //the zoom level of the map. Use values between 2 and 17
maptype=3; //use 0 for Normal map, 1 for Satellite, 2 for Hybrid, 3 for Terrain
trackvessel=0; //the MMSI of the vessel to track, if within the range of the system
fleet=''; //the registered email address of a user-defined fleet to display
remember=false; //true or false to remember or not the last position of the map
*********>
******** type="text/javascript" src="http://www.marinetraffic.com/ais/embed.js">*********> "

I might ask for something impossible but would be great if it worked


Thanks in advance

Jonas

 

[Scott Huish]

Insert a Microsoft Web Browser ActiveX control on your page and load your HTML into it (perhaps on the Worksheet Activate event). Replace the mrexcel.com url with wherever your HTML file is housed.

Private Sub Worksheet_Activate()
WebBrowser1.Navigate "http://www.mrexcel.com"
End Sub

 

[JWahlin]

Hi,

Thanks for the reply but i get "Object required" when using your code in excel VB

What am I missing?

Brgds

Jonas

 

[Scott Huish]

Did you put it in the worksheet module? It doesn't go in a standard module. Did you insert the Web Browser control on your sheet?

 

[JWahlin]

Hi,
I am quite new to this so cant really say i did what u ask.

I started with a new file, went to the VB interface (Alt+F11) then put the command under the code for "ThisWorkbook" but nothing happens when i open the file so i must be missing a few steps.

What is the Web Browser Control i should insert on my sheet, how do i do that?


Thanks

Jonas

 

[Scott Huish]

In XL2007 or higher, click on the Developer tab.
Click on Insert
Under ActiveX Controls, click on the More Controls button, the lower right, and the select Microsoft Web Browser from the list. Click OK.
Then draw it on your screen.
You can then right click it. Click on properties and change any properties you like.

 

[JWahlin]

Thanks alot!

I got the webpage to my excel sheet, now I just have to figure out how to configure it the way i want...


Great help, thanks again

Jonas

 

[Onslaught17]

Hello,

I am also trying to do this exact same thing. I followed the directions but i am getting the object error message as well. My experience with Excel is beginner-intermediate experience level. Any help or elaboration would be greatly appreciated?