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...
M

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...
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...
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...
Oben