Hi, is it possible to export the PrintArea of active sheet to an image?
Thanks a lot.
Hi, is it possible to export the PrintArea of active sheet to an image?
Thanks a lot.
Hi
Like this?
Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Fotis, that copies the image, but doesnt export the file.
This ones a bit tricky, there are some examples on how to do it, but it would be that code above, then pasting from the clipboard to a new bitmap file.
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Exactly. ,,,,,,,,,,,,,,,,,,,,,,
Can't you just have PDF creator installed, and create a vba script to print the file?
Thanks for all the responses. The thing is, I need this to be completely automatic and also "PrintArea based", not "hardcoded-range based".
And this is why:
I have a 30-pages report. Each page is on its own sheet defined by PrintArea of that sheet.
Now, I want to make 30 pictures of those 30 pages, next month again with new version of that report and so on. In the end, I will "transpose" the pictures to get a time-row of each page of that report.
In other words - I need to go from this:
Set of reports (in month M)
M1 Pages: 1, 2, 3, ... 30
M2 Pages: 1, 2, 3, ... 30
M3 Pages: 1, 2, 3, ... 30
...
M12 Pages: 1, 2, 3, ... 30
To this:
Set of pages (for all months):
Page 1: M1, M2, M3, ... M12
Page 2: M1, M2, M3, ... M12
...
Page 30: M1, M2, M3, ... M12
Hope, that makes sence. I'll do manually the transposing, I just need to automate the picture making.
bump, no response.
Well google it, me & some others have offered how to do it. Copy the print range to picture, you'll need to do some digging on how to send it to a bmp file. Piece of cake in .NET
Ok, thanks for the hints, I have found what I need.
I copy the image like Fotis1991 suggested.
I save it uisng this advice.
In the end, I loop it through the workbook.
Last edited by bristly; 09-18-2014 at 09:15 AM.
Yes, that will be fine. The creation of the bitmap code is pretty intense
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks