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!
Bookmarks