Hello
I have a few overlaid charts - I need to export them all as one single image to a png file - can you please help me do this via a vba?
Ideally a range a2:c60 should be exported to png file using the name from cell d1 - "Screenshot"
Or woudl be easier to via VBA to use the camera and point to this range and export as PNG?
Thanks many times!)
I found this code but it does nto seem to work:
not sure why it consist of two separate macros?
Please Login or Register to view this content.
???
Macros work, you only need to change (in short) the range "B2:H8" to "A2:C60" and "J3" to "D1".
You can also combine both into one, e.g.:
Please Login or Register to view this content.
please see my last reply - thanks a lot!)!))
Last edited by zealot; 11-13-2020 at 03:04 AM.
\\Originally Posted by porucha vevrku
???
Macros work, you only need to change (in short) the range "b2:h8" to "a2:c60" and "j3" to "d1".
You can also combine both into one, e.g.:
Please Login or Register to view this content.
fantastic script - this seem to work perfectly
can you tell me what this line means?
with rrng.parent.chartobjects.add(10, 10, 200, 200)
The above macro effectively overcomes excels vba limitations and exports a camera image as png using cell value as png name - I just had to move the camera image to a new complete clear worksheet and focus the camera on original overlaid charts
I now wanted to ask if this macro can be made to export higher resolution chars? I wonder if this line affects image resolution?
with rrng.parent.chartobjects.add(10, 10, 200, 200)
I can of course enlarge the camera picture itself but was wondering the VBA can make smaller images with more clarity?
Last edited by zealot; 11-13-2020 at 03:02 AM.
The code resizes the chartobject to the width and height of the captured range.
You could try changing the Image Size and Quality setting within the Advanced section of File > Options.
Thank you Andy - my dpi for image export is set at max 220 dpi - will changing any of these numbers add to image quality?
with rrng.parent.chartobjects.add(10, 10, 200, 200)
Those values are the dimension of the newly added chartobject, left, top, width, height.
The code then resizes the chartobject width and height to match the copied image/range size.
If that setting made no difference to the image quality then I doubt there is anything that you can do to change things.
You could make then original objects larger so the quality may be better if you then reduce the size of the generated image.
thank you Andy - there is a handy service -tinypng.com - the output file from excel is 256 kb png file but when scaled down by tinypng.com it goes down to 70 kb - can enlarge the charts to get better resolution
???
Macros work, you only need to change (in short) the range "B2:H8" to "A2:C60" and "J3" to "D1".
You can also combine both into one, e.g.:
Please Login or Register to view this content.
I am having the following error randomly showing when I loop through the data and try to export like 100 pictures...first this error appears at image number 35 then 78...
VBA Error 1004 - CopyPicture method of Range class failed
the following line is highlighted :
rRng.CopyPicture Appearance:=xlScreen, Format:=xlPicture
can you please help??? why this can be happening?
maybe there is another way to make this macro work or to export the range as png?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks