MSCom
Neuer Benutzer
Threadstarter
- Dabei seit
- 20.09.2016
- Beiträge
- 1
Good day everyone,
I have been working on a workaround to save several Graphs as Images into a folder.
On Windows this is quite simple, on Mac still a problem for me. I hope anyone can help me out.
What I did so far in simple coding:
'Select Sheet and copy Graph
Sheets("UKI").Select
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.ChartArea.Copy
'Select Sheet to paste (and then export)
Sheets("Picture").Select
Range("A1").Select
ActiveSheet.Paste
'Export as png/jpeg/... (choose format)
ActiveChart.Export ("/Users/" & UserName & "/pictures/FY1718UKI.png"), FilterName:="png"
This Does not export the file. (Error message on the last step!)
On Windows it works though (changing the path for Windows)!
IMPORTANT NOTE !!! I am able to export graphs as images using the shape-method !!! (copy into shape, then export as png), but this method results in poor quality. - So DO NOT PROVIDE me with the SHAPE METHOD workaround please.
So i want to acheive the export on Mac as a normal picture (saveaspicture) to work as it does on Windows!
Thanks for your help,
Fabian
I have been working on a workaround to save several Graphs as Images into a folder.
On Windows this is quite simple, on Mac still a problem for me. I hope anyone can help me out.
What I did so far in simple coding:
'Select Sheet and copy Graph
Sheets("UKI").Select
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.ChartArea.Copy
'Select Sheet to paste (and then export)
Sheets("Picture").Select
Range("A1").Select
ActiveSheet.Paste
'Export as png/jpeg/... (choose format)
ActiveChart.Export ("/Users/" & UserName & "/pictures/FY1718UKI.png"), FilterName:="png"
This Does not export the file. (Error message on the last step!)
On Windows it works though (changing the path for Windows)!
IMPORTANT NOTE !!! I am able to export graphs as images using the shape-method !!! (copy into shape, then export as png), but this method results in poor quality. - So DO NOT PROVIDE me with the SHAPE METHOD workaround please.
So i want to acheive the export on Mac as a normal picture (saveaspicture) to work as it does on Windows!
Thanks for your help,
Fabian