Print Screen? (SOLVED)

[dowingc]

I have a userform that I would like to save as a jpg or bmp. Do you know of code to do a print screen and save as jpg or bmp? Basically, I want to be able to view this userform over the web as a web page. Thanks!

Chris

 

[dowingc]

Unfortunately this does have to be done VBA do to job restraints, or else 3rd party software would be great Saving the form as a .html from MSWord would be fine if you know how to do that, hopefully it wouldn't degrade the quality to the point the text was unreadable, it shouldn't though....Thanks!

Chris

 

[Juan Pablo González]

"My" code works entirely with VBA... try it out...

 

[dowingc]

Outstanding! Using a combination of all your ideas I was able to accomplish the task. Thank you all very much!

Chris

 

[Tom Urtis]

My thanks also to Ivan Moala and Juan Pablo Gonzales...great example of what teamwork and API can accomplish.

 

[dowingc]

Re: Print Screen?

This technique worked for me however I am running into a memory leak problem and am not sure if it is this code or not. The program I am working on is designed to run 24/7 and this screenshot code will be ran about every 3-5 minutes, hopefully forever at that rate Can anyone say if they have sucessfully ran this code for extended periods of time? Mine will run for around 2 days and then start causing some memory and video problems and require a reboot. Thanks!

Chris

 

[golf4]

Hi, Tom -

Just a word of thanks on your suggestion on the Shift+Edit option. It works really slick.

Thanks and take care,

Golf

 

[Tom Urtis]

Ha ha...thanks for the update after these 6 months. Always something new to learn !!!

 

[kumarapush123]

There is another alternate method to take print screen and save it as an image file.

http://officetricks.com/print-screen-save-as-image-file-attach-to-sheet-automate-in-vba/

The code in this topic automates the key strokes Alt Tab, Print Screen and Save as Image file to a specific path.