Automating taking screenshots of Excel ...

[fivenastydisco@hotmail.com]

I have to take regular screenshots of part of a Excel worksheet to post
to a website, and I'm getting sick of it!! Does anyone know a way to
automate taking a screenshot of a set range in a worksheet, and saving
it as a local file (e.g. a GIF file), using VBA?

I've done something similar in the past to save Excel charts to a
graphics file, but am struggling when doing the same with worksheet
entries -- any thoughts?

JW

[Dave Peterson]

David McRitchie has some code from Harald Staff. You may find it interesting.
http://www.mvps.org/dmcritchie/excel/xl2gif.htm

fivenastydisco@hotmail.com wrote:
>
> I have to take regular screenshots of part of a Excel worksheet to post
> to a website, and I'm getting sick of it!! Does anyone know a way to
> automate taking a screenshot of a set range in a worksheet, and saving
> it as a local file (e.g. a GIF file), using VBA?
>
> I've done something similar in the past to save Excel charts to a
> graphics file, but am struggling when doing the same with worksheet
> entries -- any thoughts?
>
> JW

--

Dave Peterson