Email Embedded Microsoft Browser Map

[Galius]

Hey Guys,

So I have a basic spreadsheet here where I put addresses and then click View Map and it'll load the map in an embedded Microsoft Web Browser ActiveX Control. All I want to do is right a script to basically screenshot that embedded map then paste it in an email to send.

Google Map Excel.xlsm

drive.google.com

I've uploaded the sheet to the google drive above. I tried posting images but it kept telling me too large even though they were only 250kb.

 

[Dan_W]

Hi - I'm actually helping someone with something at the moment that might also assist you? Save active (current) Userform to Desktop as .png

 

[Galius]

Hi - I'm actually helping someone with something at the moment that might also assist you? Save active (current) Userform to Desktop as .png

Hey Dan,

I had a look at the above code and added it to a button. It will take a screenshot and save it to the desktop, but the screenshot is of the entire spreadsheet not just the web browser map. How would I change it to only to screenshot that only?

Google Map Excel.xlsm

drive.google.com

Updated sheet with your code.

 

[Dan_W]

It actually takes a snapshot on the currently active window. So if the button is on the userform, then it will take a snapshot of the userform. If the button is on the worksheet, then it will take a snapshot of the worksheet. It should be possible to get a snapshot of just the webbrowser control, but I would need to check. I tried checking your file from the original post, but it didn't have a userform in it. Have you since updated it?

 

[Galius]

O

It actually takes a snapshot on the currently active window. So if the button is on the userform, then it will take a snapshot of the userform. If the button is on the worksheet, then it will take a snapshot of the worksheet. It should be possible to get a snapshot of just the webbrowser control, but I would need to check. I tried checking your file from the original post, but it didn't have a userform in it. Have you since updated it?

Oh! Sorry mate mine actually didn't have a userform just a Microsoft Web browser control, but it should still be able to to work off that shouldn't it?

 

[Dan_W]

Ahh - so where is the webbrowser control? Did you draw it directly on the worksheet?

 

[Galius]

Ahh - so where is the webbrowser control? Did you draw it directly on the worksheet?

Yes, I just dragged and drew it on the worksheet.

 

[Dan_W]

Ahh. Sorry if it seems like a stupid question - it's just I forgot that you can do that with 32bit Excel and you user info details didn't show your version of Excel.
I'm using 64bit - Excel doesn't allow us to draw the webbrowser onto the worksheet anymore, so when I open your workbook, all I see is the table and some buttons. When I try and click on one of the View Map buttons, it produces an error - Excel strips the control from the workbook when I try and open it.

But anyway, it may not matter. Although I like to test these things properly myself on my system at home first (and I obviously can't here), It should still be the same method of taking the snapshot as what I was thinking of adding to the Userform version with a slight tweak. We will have to try it and see. Let me look at it again later today.

 

[Galius]

Ahh. Sorry if it seems like a stupid question - it's just I forgot that you can do that with 32bit Excel and you user info details didn't show your version of Excel.
I'm using 64bit - Excel doesn't allow us to draw the webbrowser onto the worksheet anymore, so when I open your workbook, all I see is the table and some buttons. When I try and click on one of the View Map buttons, it produces an error - Excel strips the control from the workbook when I try and open it.

But anyway, it may not matter. Although I like to test these things properly myself on my system at home first (and I obviously can't here), It should still be the same method of taking the snapshot as what I was thinking of adding to the Userform version with a slight tweak. We will have to try it and see. Let me look at it again later today.

Thanks Dan, let me know how you go. It actually didnt work for me either at first, had to edit the registry to make it work. You can see that HERE if you'd like.

 

[Dan_W]

So much for those security concerns.. LOL. Thanks. I'm not a huge fan of ActiveX controls on worksheets, but it's useful to at least have the option. While you're there, do you know what version of Excel you're using and its bitness (32 bit or 64 bit)?