+ Reply to Thread
Results 1 to 8 of 8

Export Print Areas of all sheets to images

  1. #1
    Forum Contributor
    Join Date
    11-13-2007
    Location
    Prague
    Posts
    145

    Export Print Areas of all sheets to images

    Hi,

    I have a multiple-sheet report (20+ pages) and need to convert it regularly to set of images.
    At first, I was thinking about exporting the report to PDF and exporting the pages from there, but this would require additional software or uploading the file to on-line services, which I cannot do since the report is confidential.
    So, is there a way I can acomplish this via macro? I was unable to google the solution so far.
    The perfect way the macro should operate would be this: for all visible sheets export the Print Area to image named by the sheet name and save it to the folder of the report.
    If there is any other easy way to acomplish this, I'll go with it, I just don't wanna do it manually, nor install anything, nor upload the report.

    Any ideas would be highly appreciated!
    Last edited by bristly; 06-09-2014 at 03:38 AM.

  2. #2
    Forum Contributor
    Join Date
    11-13-2007
    Location
    Prague
    Posts
    145

    Re: Export Print Areas of all sheets to images

    Bump......

  3. #3
    Forum Contributor
    Join Date
    11-13-2007
    Location
    Prague
    Posts
    145

    Re: Export Print Areas of all sheets to images

    Bump, no response. Still hoping somebody can help.

  4. #4
    Forum Contributor
    Join Date
    11-13-2007
    Location
    Prague
    Posts
    145

    Re: Export Print Areas of all sheets to images

    Ok, let's make the enquiry less complex:
    Is it possible to export the PrintArea of active sheet to an image?

  5. #5
    Forum Contributor
    Join Date
    11-13-2007
    Location
    Prague
    Posts
    145

    Re: Export Print Areas of all sheets to images

    Bump, no reponse.

  6. #6
    Forum Contributor
    Join Date
    11-13-2007
    Location
    Prague
    Posts
    145

    Re: Export Print Areas of all sheets to images

    Bump, no reponse.

  7. #7
    Forum Contributor
    Join Date
    11-13-2007
    Location
    Prague
    Posts
    145

    Re: Export Print Areas of all sheets to images

    Bump, no reponse.

  8. #8
    Forum Contributor
    Join Date
    11-13-2007
    Location
    Prague
    Posts
    145

    Re: Export Print Areas of all sheets to images

    Bump, no response.

+ 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. Replies: 2
    Last Post: 05-27-2014, 10:21 AM
  2. Need to Print and export sheets with data only
    By stuartgentle in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-28-2013, 06:20 PM
  3. Save as PDF and email / User defined Sheets and Print Areas
    By alexq in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-16-2010, 04:19 PM
  4. [SOLVED] How do I set print areas for multiple sheets simultaneously?
    By Twirly in forum Excel General
    Replies: 3
    Last Post: 01-09-2006, 08:20 AM
  5. [SOLVED] why do white areas in raster images print spotty
    By Rogeve33 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-08-2005, 11:05 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