AJP Excel InformationAJP Excel Information
ChartsVBAFun stuffForumsTipsLinksBooksWhat's newContactAboutSearchRSS Feed


Graphics Exporter
(Excel 2000 and above)

This add-in will allow you to export pictures, shapes, charts and more to image files.
v1.1 1st Feb 2003
  • Modified sizing to reduce area around exported image.
  • Refined routine to determine whether items have 3d applied.
  • Remove menu icon due to sizing problems.
v1.2 20th Feb 2003
  • Modified routine for menu creation, now located by ID not name, so it should work with non English versions of Excel.
v1.3 13th Dec 2003
  • Fix of bug related to cell comments on worksheet.
v1.4 8th Jan 2004
  • Modified code to use AddinInstall and AddinUninstall events.
  • Added routine to remove multiple menu entries.
v1.5 25th Nov 2004
  •  Automatic ability to export the active cell range. 
    (If the current selection is that of a multiple and contiguous cells range).
v2.0 26th Feb 2005 - This version will not work in xl97
  • Updated UI
  • User preferences including graphic filter type and a default output folder
  • Ability to add new graphic filter types
v2.1 24th Apr 2005 - This version will not work in xl97
  • Fixed bug with displaying a preview image when userform is first loaded
v2.2 3rd Jan 2006 - This version will not work in xl97
  • Handle exporting of grouped shapes
v2.4 6th Oct 2007 - This version will not work in xl97
  • Handle exporting of smart art in Excel 2007
  • Fixed bug with naming of objects on chart sheets
v3.3 2nd Nov 2008 - xl2007 version only
  • Changes to deal with xl2007 shrinking size of grouped shape when exported
  • Change required to handle export of selected range. The newly pasted image of the cells is not necessarily the last item in the Shapes collection.
I have created a version of the addin specifically for Excel 2007. It creates a new Group on the Add-Ins tab.




Last updated 2nd November 2008

  Home | Charts | VBA Code | Fun Stuff
Forum Examples | Tips | Links | What's New | Book List
Contact | About
Microsoft® and Microsoft® Excel are registered trademarks of the Microsoft Corporation.
andypope.info is not associated with Microsoft. Copyright ©2007-2012 Andy Pope