Save Chart or Chart sheet as JPG

When you try to use VBA code that is working in Excel for Windows to save a Chart or Chart sheet as jpg it is possible you get errors when you use it in Mac Excel because of Apple sandbox requirements, the location where you save the file is the problem in most situations. Read the page below if you want to know why:

Problems with Apple’s sandbox requirements

See the two examples below that use a save location that is allowed. Note: Do not forget the copy/Paste the function named CreateFolderinMacOffice into your workbook.

The files will be saved in a folder named JPGFolder in the Microsoft Office Root folder, the second macro makes a picture of the chart sheet named "Chart1", the first macro makes a picture of an embedded chart named "Chart 1" on a sheet named "Sheet1".

Web design by Will Woodgate