A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Publishing Excel Objects and Charts, png format



 
 
Thread Tools Display Modes
  #1  
Old April 7th, 2010, 09:01 PM posted to microsoft.public.excel.charting
Natalie Caballero
external usenet poster
 
Posts: 1
Default 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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:58 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.