Publishing Excel Objects and Charts, png format
 

Good morning excel experts:

Product: MS Excel 2007

I have designed a dashboard using several charts grouped as one object. For
web publication, I first use the save as function: save, save as other
format, web page (htm, html).

The result is an html file and two png image files. One png image is about
the same size as the screen display in my excel window. The other png is an
enlarged version.

For ultimate web publication, I use the screen display size image which I
import into Dreamweaver. The enlarged version is too large and does not
resize well.

I have also written a macro that does following functions: sets data, prints
the dashboards, converts and saves a pdf version and runs the above mentioned
save as html wizard (which produces an htm file and two ping files).

My problem is that I am training a co-worker to run the dashboard reports.
When the macro runs on her Excel program (the same Excel version as mine),
the save as html wizard produces an htm file, one png file and a gif file.
The png file that is produces is the enlarged version that does not resize
well for my needs.

Since the png files are the part of the save as htm wizard that I need, I
think that the best solution would be to not to rely on the save as wizard
which has different default settings (I think that is the problem, at least).
I am having trouble figuring out the vb code for converting a grouped object
to png. Could you help me out with it?

Of course, if you have another solution (like how to reset the wizard
default), I would appreciate that as well.

Thank you for your assistance,

Natalie Caballero