Menu
I’ve been trying to maintain compatibility between Mac and Windows versions of Excel/VBA apps for a while now, and it’s a pain.
These notes refer to versions 16.14 of both Excel and Powerpoint.
These notes refer to versions 16.14 of both Excel and Powerpoint.
Here are some of my recent threads on answers.microsoft.com
Passing a user-defined object to a sub As Object passes an object with all Null properties. Passing As MyClass works. Methods work, just not properties.
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, I’ve 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.
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, I’ve 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.
Vba Excel For Mac 2016 Download
1) Manual copy and paste works, as it does in Windows. I want to automate this for what could be 100 slides.
What's New in Excel 2016 and What's Changed; VBA on a Mac. In VBA & Macros for Microsoft Excel, we mentioned that we would post a list of gotchas to watch out for when you are using VBA on a Mac. Here is the list: Application.ScreenUpdating doesn't work; Usersform - don't recommend using big labels. We have no control over the fonts, so it can. Below you can find example VBA code to save as PDF in Mac Excel 2016. Microsoft fixed a few bugs but there are still a lot of bugs to fix, so I will update the code when needed. The code will create a folder in the Office folder to save the PDF files in, read the info on this page why I use a folder in that location.
2) The CopyPicture method fails for all objects. Range gives error 1004 CopyPicture method of Range class failed. ChartArea gives error 438 Object doesn’t support this property or method. Chart.Copypicture the result when pasting is a shape with text “The picture can’t 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)
Vba Excel For Mac 2016 Version
See my post on answers.microsoft.com.
To work around this, create the picture in Excel:
To work around this, create the picture in Excel:
3) There is no Slide.PasteSpecial method in Mac Powerpoint VBA. Slide.Paste takes NO data type argument.
4) ApplescriptTask can be used to execute the Paste in Powerpoint. Thanks to Ron de Bruin for help here.
This code is in the VBA:
Save this code in a file eg “CopyPasteScript.applescript” in the special folder
/Users/myusername/Library/Application Scripts/com.microsoft.Excel
/Users/myusername/Library/Application Scripts/com.microsoft.Excel
5) Another method is to export the Chart as a picture and then import it in PowerPoint
6) In practice, the above method is agonisingly slow, so what I really do is write a VBA script with lines that create a presentation, add slides, set the title text, and call AddPicture using the file names created.
Then I create a temporary presentation in PowerPoint, import that VBA code, execute it, and close the temporary presentation without saving it.
Then I create a temporary presentation in PowerPoint, import that VBA code, execute it, and close the temporary presentation without saving it.
7) Before Chart.Export started to work in Excel 16.14 or later, I did try the ugliest workaround, and it works but it’s really a kludge.
![Vba Excel For Mac 2016 Vba Excel For Mac 2016](/uploads/1/1/8/5/118590513/844998755.png)
7.1 Create a temporary workbook with a sheet for each slide and copy/paste the title and chart image into it. Add needed properties to the .AlternativeText of the pictures.
![Microsoft excel 2016 for mac Microsoft excel 2016 for mac](/uploads/1/1/8/5/118590513/866043381.jpg)
7.2 Save the workbook as html.
7.3 Open the tabstrip.htm file, read the text, split it at “<a href=” and extract the tab names.
7.4 for each tab file name, open its htm file, read the text, split it at “<v:shape id=” and parse out the picture file names and properties.
7.5 Now I have the picture file name, add a line to the PowerPoint VBA file I create in (6) above to add a slide using the right title and picture filename.
Horrible, isn’t it?
Horrible, isn’t it?
gio123bg
Active Member
Hi All,
in Excel 2016 for Mac I have enabled the Developer tab to have la possibility to show the code of a Button but I can't find the same situation as I have in Excel 2016 for Windows. More exactly in Exec 2016 for Windows, to show the code related to a Button I select 'Developer tab', under 'Controls' I select 'View Code'. I would like to have the same possibility in Excel for Mac.
Any suggestion will be greatly appreciated.
Thanks in advance for your kind support.
Regards,
Giovanni
in Excel 2016 for Mac I have enabled the Developer tab to have la possibility to show the code of a Button but I can't find the same situation as I have in Excel 2016 for Windows. More exactly in Exec 2016 for Windows, to show the code related to a Button I select 'Developer tab', under 'Controls' I select 'View Code'. I would like to have the same possibility in Excel for Mac.
Any suggestion will be greatly appreciated.
Thanks in advance for your kind support.
Regards,
Giovanni