Hi All,

I'm really kinda stuck with porting an existing project that has been working for years. The update I'm trying to solve is to support Office for Mac 2016. Similar code works on Office for Mac 2011, I'm aware of the sandboxing restrictions but I would be surprised if this is related to that.

For some reason I can't figure out why the code is generating an out of memory error. It is generating the error at the "Set mybook = XLApp.Workbooks.Open(MyFiles)" line.

The concept code is below, to use it all you need to do is create a PPT macro enabled file and place the code in there. Also create a seperate workbook and place any value in cell A1.

The code uses the concepts from Ron de Bruin, but been tweaked to open up an Excel workbook from inside PowerPoint. In theory it should simply print the value stored in cell A1. Excel is launched, and the file is opened but then it throws the error.

Any help to solve would be greatly appreciated, I've already spent quite a lot on trying to get it to work.

I'm running the latest macOS with Office for Mac 2016.

Thanks in advance!

Steve

Please Login or Register  to view this content.