select excel file that works both for mac and windows vba

Select Excel File That Works Both And Windows Vba Code To Create

These notes refer to versions 16.14 of both Excel and Powerpoint.

Interoperability between Excel 2016 for Mac and Powerpoint 2016 for Mac is very frustrating.

To get VBA to copy a picture of a chart to a slide, Ive tried four different ways.

Only in the latest Insider Build 16.14 does the obvious Copy Paste method work but even that requires copying and pasting as an image in Excel first and then copying amd pasting the static picture.

Range gives error 1004 CopyPicture method of Range class failed.

ChartArea gives error 438 Object doesnt support this property or method.

Chart.Copypicture the result when pasting is a shape with text The picture cant be displayed.

Update 8-May-18: Excel 16.14 (180507) Chart.Copypicture now works, includes a TIFF format in the copied data.

And to save a picture of a range as a file, we can now do range.copypicture followed by adding a temporary chart by chartobjects.add and then chartobject.chart.paste of the picture, then chart.export as PNG).

Add needed properties to the.AlternativeText of the pictures.

Is it supported in mac OS 10.14 Excel 2019 Thank you for your help.

Select Excel File That Works Both And Windows Vba Code To Create

I now save all the pictures I want to paste as files, write VBA code to create the presentation to a file and import it to the Powerpoint instance and run it there.

Set mPPPres mPPAppObject.Presentations.Add a blank presentation to hold the VBA.

I bought a Mac Mini to work on an addin for a client a couple of years ago.

I havent turned it on since that project finished, maybe I could bring it home as a TV server or something.

To find out more, including how to control cookies, see here.

Select Excel File That Works Both For Mac And Windows Vba