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.

 

[Galius]

Ok, I really need to see exactly what's happening because I've tried this on 22 different non-visible windows/window handles, and they all worked, so I'm at a bit of a loss.

Can you please show me:
(1) a full screen capture of the webbrowser control in the worksheet in Excel;
(2) the image that you want to have output at the end of it; and
(3) the images that you're instead getting (through methods #1, #2, and now #3) (i.e., the 'failures').

i suspect that something else is causing the problems, but I can't quite think what it might be. Thanks.

Hey Dan, I think what I might do is just build into the macro to move location so it captures the whole screen then move back. I tried that and it worked great so I don't think there's any need to work on it anymore. Thanks heaps for all your help.

 

[Dan_W]

Well that's actually what the first attempt above does - it takes a full screen capture, and then crops it to the dimensions/location of the window handle - but again, that would require that it be visible. I had hoped that this new PrintWindow would solve that problem, but if that's still not working for you, I'm not sure what the problem could be. The only other thing it might be is if you're still using an existing workbook - it may be worth just starting a brand new workbook, adding this code, and adding a new webbrowser control to that new workbook and see how it goes. Good luck!

 

[Galius]

Well that's actually what the first attempt above does - it takes a full screen capture, and then crops it to the dimensions/location of the window handle - but again, that would require that it be visible. I had hoped that this new PrintWindow would solve that problem, but if that's still not working for you, I'm not sure what the problem could be. The only other thing it might be is if you're still using an existing workbook - it may be worth just starting a brand new workbook, adding this code, and adding a new webbrowser control to that new workbook and see how it goes. Good luck!

Thanks for all the help Dan! Legend!