+ Reply to Thread
Results 1 to 2 of 2

Is it possible to save areas of a spreadsheet as image files via vba?

  1. #1
    Forum Contributor
    Join Date
    12-01-2010
    Location
    Southampton, England
    MS-Off Ver
    Excel 2007
    Posts
    303

    Is it possible to save areas of a spreadsheet as image files via vba?

    I produce spreadsheets which is conditionally formatted to be both functional and aestheticly pleasing. The tables are seperated by one line, and can easily be defined by VBA, I was wondering if it is be possible to export them as image files via vba? I know it can be done for graphs, but not sure about defined sections of the worksheet?

    Any help comment or advise would be greatly appreciated.

    Thanks

    Alan

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Is it possible to save areas of a spreadsheet as image files via vba?

    Under the Home ribbon - Clipboard group , click on copy - You can select " Copy as picture"

    I suppose this can be mimicked using VBA?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Display external image files in spreadsheet?
    By gornalgremlin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-20-2013, 04:33 AM
  2. [SOLVED] Convert a spreadsheet into a PDF and save to a choice of files.
    By redoscar in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 09-07-2012, 01:16 AM
  3. Display Specified Image In Multiple Areas Within Workbook
    By swordswinger710 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-09-2012, 01:22 PM
  4. image files linked to spreadsheet
    By grim72 in forum Excel General
    Replies: 0
    Last Post: 02-18-2011, 04:15 AM
  5. [SOLVED] inserting image and document files into the spreadsheet
    By Cornpone in forum Excel General
    Replies: 8
    Last Post: 01-30-2006, 08:55 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1