View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Jason.Rodrigue@gmail.com is offline
external usenet poster
 
Posts: 2
Default Save Userform as bitmap

I can manage to save the userform snapshot to the clipboard, but is
there a way to save the clipboard image to some sort of image file
(jpg, bmp, etc.) instead of pasting to the worksheet? That is the part
that I am getting stuck on.

The form displays the arrangement of a bunch of boxes on shelves and
shows how they are moved around, step by step. So, when the user hits
a command button, the form updates to show the new arrangement. The
point of taking the snapshot is to get a picture at each step and get
the pictures imported into a powerpoint presentation in the correct
order.

I've found a thread that shows how to import one snapshot into a slide
in a newly created powerpoint presentation, but if I try to iterate
through the steps, the snapshot gets messed up after the first one. I
think it has to do with which window has the focus, but I'm not too
sure how the api above works, just that it does.

In light of this problem, I've changed my approach to to save a
snapshot of each step as some type of image file and then I can import
them into powerpoint later. Plus it would be nice to have the image
files saved into a folder instead of directly importing them from the
snapshot. But, once again, I'm stuck. How do I save a clipboard image
to some port of image file?

Thanks in advance,
Puck312