Print embedded active x object via vba

It appears from the lack of responses..that printing the embedded map is not possible. Any chance vba coding could be used to somehow capture the map image like via a print screen function but just of the map image and then save the image to a folder as a jpeg? Thanks for any/all input!

I've been searching the web trying to figure out how I can get this to print out or do a "print screen" type effect to eventually be able to print out the map portion, etc. I'm attaching a modified example of some vba code that is suppose to do a "print screen" then copy image to new workbook, but I'm getting the following error message "Clipboard corrupted, possibly by another task". The code is placed in a module, which can be activated by a button in my example-some comments edited to meet required posting limits:

Please Login or Register  to view this content.

Any help getting this code to work properly would be greatly appreciated!

From looking into this further. It appears the "print screen" functionality is working from the vba code posted above as well as it opening up another workbook to paste an image into. Currently it has an empty frame for the image to go into. If one were to however right click on their mouse and click "paste" the image would go into that framed area. So it appears that the code isn't completing the final "paste" function properly...and instead giving a message prompt as dictated in the code.

I cant get this to work for me, anyone have a working workbook.

Thanks

See if this example attachment will do the job for you.

Thanks I havent tested it yet, The site is blocked at work getting it unblocked now, will let you know how it goes, Thanks for all your work