Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
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,
Bryan



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

Tags
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 - Senior Forums

All times are GMT -7. The time now is 06:53 AM.


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