VBA: Export graphs as images on MAC

Diskutiere VBA: Export graphs as images on MAC im Office Forum im Bereich Microsoft Community Fragen; 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...

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
 
Thema:

VBA: Export graphs as images on MAC

VBA: Export graphs as images on MAC - Ähnliche Themen

Using Vlookup on other Workbook whichs path is stored in a Cell: Good Day Im Trying to do Vlookup on a closed Workbook whichs path is stored in a Cell. For that im writing a Function which opens the Workbook...
Same self-signed code signing certificate for all users on same computer ?: On my own local PC with Office 2019, I would like all accounts to use the same certificate for Office macros (Word, Excel, Access). Otherwise...
Office 365 won't start: hi there, does somebody know how to solve following problem: i installes office 365 and then opened word. after working on it i saved it and...
Outlook 365: Integrate an e-mail account twice, as POP3 AND IMAP: Hi, in Outlook 365, I would like to add an e-mail account twice: One time as POP3, the other time as IMAP. However, Outlook is not permitting me...
MS Word Mac (16.35) is not printing Hidden Text when exporting PDF (Best for electronic distribution and accessibility - uses Microsoft online service: MS Word Mac (16.35) is not printing Hidden Text when exporting PDF (Best for electronic distribution and accessibility - uses Microsoft online...
Oben