Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 06-22-2011, 07:22 PM
judicial85 judicial85 is offline Excel's Export png file Windows 7 Excel's Export png file Office 2010 (Version 14.0)
Advanced Beginner
Excel's Export png file
Join Date: Nov 2010
Posts: 64
judicial85 is on a distinguished road
Default Excel's Export png file

Hello all!

I had a question about the VBA code "ActiveChart.Export". I can use this to export (at least) a .png file for a graph/chart; what I can't do is specify the resolution (i.e. 300, 600, 900 dpi)!

What I find, which is really bad, is if the graph is zoomed in to a certain distance, it's resolution will be better than the corresponding zoomed out version! This can easily lead to very inconsistent or very low resolutions...

(a) Is there any way to export graphics AND specify a resolution?

(b) Aside from png, can other formats be exported?
Specifically, academic journals request "*.TIF, 600 dpi".

Many thanks,

PS - This is a 2010 version, but is the same with 2007
Reply With Quote

excel2010, png, resolution

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Going from Outlook 2003 to 2010, can't export the pst file Ckingfly Outlook 2 07-10-2011 10:03 PM
Office Settings is their a way to export or save to file CalExplorer Office 0 10-29-2010 09:13 AM
Export to Word dr223 Word 1 10-19-2010 07:24 AM
Export/Import Arkmom Outlook 0 03-31-2009 02:47 PM
Outlook e-mail addresses Export to a CSV file ronb Outlook 1 03-24-2009 07:45 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:13 AM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd. is not affiliated with Microsoft