Microsoft Excel

Ron de Bruin
Excel Automation

Microsoft MVP Program

What's New on rondebruin.nl

Note : Last update or new added page is on top of this page

21-Sept-2017 : Get path of Special folders on Mac. Read More

14-Sept-2017 : Updated the code to mail as workbook or PDF with Mac Excel 2016 with Mail with different examples for Sierra because of the signature bug. Read More

29-July-2017 : Updated the code on this page : "Make and Mail PDF files with VBA code on your Mac" because Microsoft fixed some bugs. Read More

8-May-2017 : Updated the code on: Sending mail from Excel with CDO (send mail without a mail program). Read More

13-March-2017 : Update the code and add-in to mail as workbook or PDF in Mac Excel and Outlook 2016. Read More

13-March-2017 : Update the code to save/mail as PDF in Mac Excel and Outlook 2016. Read More

11-March-2017 : Update the code to save as PDF in Mac Excel 2016. Read More

10-Jan-2017 : Update How do I change Backstage(File) view in Excel 2010-2016 with a new idMso so it disable every control in backstage in Excel 2016 if you want. Read More

10-Jan-2017 : Update the dictator files in the download so it it also Disable Share in the Ribbon. Read More

10-Jan-2017 : Update the download for Excel 2016: Change built-in groups in the Ribbon in Excel 2007-2016. Read More

3-Jan-2017 : New Script: Setup your Mac for Mac Office 2016. Read More

2-Jan-2017 : Update the Add-in with now 1671 working imageMso's for Mac Office 2016. Read More

28-Dec-2016 : Update: Create/use custom or default sheet templates in Mac Excel. Read More

28-Dec-2016 : Update two pages: Test if it is a Mac or a Windows Machine and Mac Excel version and Mac Office language settings.  Read More

24-Dec-2016 : Update the Date Picker Add-in for Mac Excel 2016 for Windows with a new option that automatic close the add-in after you double click on a Date, version 2.1. Read More

12-Dec-2016 : Update the Date Picker Add-in for Excel 2007-2016 for Windows with a new option that automatic close the add-in after you double click on a Date, version 1.5. Read More

4-Dec-2016 : Update: Create a summary worksheet from different workbooks (formulas created with VBA macro in Mac Excel), now also working in Mac Excel 2016. Read More

4-Dec-2016 : New Add-in: FileName Lister Add-in for Excel 2016 for the Mac. Read More

4-Dec-2016 : Update : Loop through Files in Folder on a Mac (Dir for Mac Excel) Read More

23-Nov-2016 : New tool created by Dennis Wallentin: VBA Code Indentation tool. Read More

20-Nov-2016 : Update Tab and Group idMso's of the Mac Excel 2016 Ribbon page. Read More

19-Nov-2016 : Add macro example to publish each worksheet to PDF on Mac Excel 2016. Read More

15-Nov-2016 : Add-in with 1348 working imageMso's for Mac Office 2016. Read More

5-Nov-2016 : Rob Bovey's Chart labeler for the Mac (Excel 2016) released
Briefly! XY Chart Labeler adds the ability to add labels to XY chart data points. Read More

5-Nov-2016 : Fixed the download problem of my Mail add-in for Excel 2007-2016 for Windows : Read More

4-Oct-2016 : New mail code examples and add-in for Excel/Outlook 2016 for the Mac. Read More

16-Sept-2016 : Menu for favorite Macros in Mac Excel 2016. Read More

4-Sept-2016 : RDBMailActivesheet Add-in : Add-in with a option to send the Activesheet with Mac Mail as workbook or PDF in 2016. Read More

1-May-2016 : Make and Mail PDF files with VBA code on your Mac. Read More

28-April-2016 : Update: How do I change Backstage(File) view in Excel 2010-2016 for Windows with two new idMso's for 2016. Read More

22-April-2016 : New tool created by Dennis Wallentin: Windows API Viewer for MS Excel. Read More

22-April-2016 : Update : AppleScriptTask in Office 2016 for the Mac page with a example to create scpt files with VBA code. Read More

9-April-2016 : Make folder in the Office folder in Office 2016 and create shortcut on the Desktop with VBA. Read More

5-April-2016 : Make PDF files with VBA code on your Mac in Excel 2016. Read More

31-March-2016 : RDBMerge add-in for Mac Excel 2016 (beta) released. Read More

27-March-2016 : Update : Show hidden Files and folders on Mac. Read More

27-March-2016 : Update : Select Folder with VBA/Macscript in Mac Office 2011 and 2016. Read More

25-March-2016 : Update : Mail from Excel 2016 with Mac Outlook 2026 with VBA. Read More

20-March-2016 : Update Browse to file example on this page : Problems with Apple’s sandbox requirements and Mac Office 2016 with VBA code. Read More

20-March-2016 : Select files on a Mac (GetOpenFilename). Read More

16-March-2016 : Update : Mail from Excel 2016 with Mac Mail with VBA. Read More

13-March-2016 : Update : AppleScriptTask in Office 2016 for the Mac. Read More

5-March-2016 : Update : Problems with Apple’s sandbox requirements and Mac Office 2016 with VBA code. Read More

9-Jan-2016 : New page : Problems with Apple’s sandbox requirements and Mac Office 2016 with VBA code. Read More

20-Dec-2015 : Update : SaveAs and FileFormat numbers in Mac Excel. Read More

6-Dec-2015 : Update : Add some options to the VBA mail codes (Mac Mail) for Excel 2011, you can add more mail addresses now in the To, CC and BCC and it add the default signature to the mail. Read More

29-Nov-2015 : Update code : Fixed an attachment bug in the VBA mail codes (Mac Mail) for Excel 2011 installed in El Capitan. Read More

25-Nov-2015 : New Add-in : Dynamic Menu for your favorite macros in Excel 2007-2016. Read More

23-Nov-2015 : Update : Test if it is a Mac or a Windows Machine. Read More

18-Nov-2015 : Add information about the 1348 imageMso's that you can use in Mac Excel 2016. Read More

13-Nov-2015 : Update my basic Ribbon example files for Windows Excel. Read More

13-Nov-2015 : Update my Ribbon Backstage page with the new idMso of the Publish tab in Excel 2016. Read More

10-Nov-2015 : Change the Ribbon in Mac Excel 2016. Read More

1-Nov-2015 : Duplicate Built-in groups in Excel 2016 for Windows with RibbonX, it give you all the idMso's of the controls in the Excel 2016 Ribbon. Read More

27-Oct-2015 : Update: Mail from Mac Excel 2016 with Mac Mail or Outlook. Read More

26-Oct-2015 : Update the Mail Worksheets Templates downloads for Excel 2007-2016 for Windows. Read More

25-Oct-2015 : Update the RDBMail Add-in for Excel/Outlook 2007-2016 for Windows. Read More

21-Oct-2015 : Date Picker Add-in for Mac Excel 2016 (Beta version). Read More

6-Oct-2015 : Update the Date Picker Add-in for Excel 2007-2016 for Windows. Fixed a userform Height and Width bug for Excel 2016. Read More

28-Sept-2015 : Update text on the mail pages for Excel 2016 for the Mac, fixed two important typos. Read More

28-Sept-2015 : Update page: AppleScriptTask in Office 2016 for the Mac, fixed two important typos. Read More

27-Sept-2015 : Update the custom Dir function for the Mac. Read More

27-Sept-2015 : Update the code to merge workbooks for the Mac. Read More

26-Sept-2015 : New page: AppleScriptTask in Office 2016 for the Mac. Read More

7-Sept-2015 : Update: Select files on a Mac (GetOpenFilename). Code is also working in Mac Excel 2016 now. Read More

18-Aug-2015 : Update: Create/use custom or default sheet templates in Mac Excel. Code is also working in Mac Excel 2016 now. Read More

15-Aug-2015 : Update: Mail from Excel 2016 with Mac Mail, add sender and signature option to the code examples. Read More

3-Aug-2015 : New: Mail from Excel 2016 with Outlook 2016. Read More

3-Aug-2015 : Update: Mail from Excel 2016 with Mac Mail. Read More

28-July-2015 : New: Mail from Excel 2016 with Mac Mail. Read More

22-July-2015 : Update the Windows DatePicker (add the Danish language). Read More

8-July-2015 : Update the code to get the path of Special folders on Mac. Read More

26-June-2015 : Update the code to check if a File or Directory exists on the Mac. Read More

25-June-2015 : Update the code to create a folder on the Mac. Read More

25-June-2015 : Update the code to kill files on the Mac. Read More

1-June-2015 : Update the Windows DatePicker with a option to use it in your own userform. Read More

28-April-2015 : Add a important note in the CDO gmail example. Read More

26-April-2015 : Update the Detect Mac OS X version number page. Read More

28-March-2015 : Update the custom Mac GetSaveAsFileName function. Read More

21-Feb-2015 : Update the VBA code to Create and Mail PDF files with Excel 2007/2013. Read More

12-Jan-2015 : Update the RDBMerge Add-in for Excel for the Mac to version 1.3. Read More

1-Jan-2015 : Update the Custom Dir function for Excel for the Mac so it also is working with folders with a apostrophe in the folder name. Read More

1-Jan-2015 : Update the Merge Excel Workbooks example code for Excel for the Mac so it also is working with folders with a apostrophe in the folder name. Read More

1-Jan-2015 : Update the RDBMerge Add-in for Excel for the Mac so it also is working with folders with a apostrophe in the folder name. Read More

9-Dec-2014 : Update the Menu for favorite macros in Quick Access Toolbar Add-in. Read More

8-Dec-2014 : Update the code to get the default mail program on your Mac. Read More

8-Dec-2014 : Update the mail add-in for Excel and Outlook or Apple Mail for the Mac. Read More

6-Oct-2014 : Add a new page in the Mac section of my site : Create/use custom or default sheet templates in Mac Excel. Read More

23-Sept-2014 : Update the RDBMerge Add-in for Excel for the Mac to version 1.1. Read More

17-Sept-2014 : Add a tip to my Copy a range from closed workbooks (ADO) page for working with a database columns with mixed data types . Read More

31-Aug-2014 : Add a complete new Date Picker add-in for Excel 2011 for the Mac installed on Mavericks(10.9), in four languages: English, German, Espa˝ol and Franšais. Read More

31-Aug-2014 : Add a new page in the Mac section of my site : Detect Mac OS X version number with VBA macro. Read More

22-Aug-2014 : Update : Detect if the Shift, Ctrl, Alt or CMD key has been pressed in Office for the Mac with a much faster example for Mavericks users using a Script Bundle File. Read More

17-Aug-2014 : Add a new page in the Mac section of my site : Detect if the Shift, Ctrl, Alt or CMD key has been pressed in Office for the Mac. Read More

14-Aug-2014 : Update : Customizing Context Menus in Microsoft Excel 2010-2013. you can download the Microsoft ContextMenuAdd-in from my site now Read More

9-Aug-2014 : Update Date Picker add-in with a common French Date format. Read More

9-Aug-2014 : Add a new page : Mac Excel version and Mac Office language settings.  Read More

2-Aug-2014 : Add a complete new Date Picker add-in for Excel 2007-2013. Read More

23-June-2014 : Update the code to test the default mail program on the Mac. Read More

15-June-2014 : New version of the Excel Function Bible released. Read More

6-June-2014 : Update the Useful Add-ins page with FastExcel. Read More

3-June-2014 : Excel Function Bible, Add a index workbook to the download. Read More

2-June-2014 : Excel Function Bible, with 468 WorksheetFunction Example workbooks. Read More

26-May-2014 : Add a new page : Useful Excel Add-Ins. Read More

12-April-2014 : Add a new page : Paste and Transpose icon in QAT crash Excel 2013. Read More

7-April-2014 : Add a new page : Test if Outlook is open and open Outlook with VBA. Read More

5-Feb-2014 : Add a new page : Copy Excel data in Word file. Read More

30-Jan-2014 : Add the last page from my old site to my new site : Dealing with Ribbons and Menus - Avoiding Two Versions. Read More

9-Dec-2013 : Menu for favorite macros in Excel 2011 for the Mac. Read More

24-Nov-2013 : Update the Date Picker for Excel for the Mac. Read More

24-Nov-2013 : Update both Date Pickers for Excel 2003-2013 for Windows. Read More

21-Nov-2013 : Add some notes on my Import and Export VBA code page.

6-Oct-2013 : Add a search option to menu of my website.

20-Aug-2013 : Update the code on this page : Mail worksheet in the body of the mail (Mac)  Read more

19-Aug-2013 : Update the function that I use in my VBA mail examples for Outlook(Mac) today, easy to add more then one person in the To, CC, BCC and add more attachments, also add a tip page for the Outlook examples  Read more

15-Aug-2013 : Add a new page : Mail worksheet in the body of the mail (Mac)  Read more

1-Aug-2013 : Add a new page : My Hardware and Software  Read more

30-July-2013 : Update the Date Picker add-in for Excel for the Mac. If correct it will work correct in every language version of Excel now Read more

28-July-2013 : Update the Date Picker add-ins(with week numbers) for Excel for Windows. If correct they will work in every language version of Excel now. Read more

10-July-2013 : Changed the Mac add-ins downloads files from .zip to .dmg files to avoid corruption of the add-ins, seems that this is a problem for many Mac users with zip files with files in it that are in the new 2007 and up formats.  Read more

25-June-2013 : Add a new page : Create a summary worksheet from different workbooks. (formulas created with VBA macro in Mac Excel)  Read more

16-June-2013 : Update my Help Context ID page with a file with the help Topic ID's for all the worksheet functions in Excel 2007-2013.  Read more

9-May-2013 : Update the Date Picker add-in for Excel for the Mac (to version 1.2).  Read more

28-April-2013 : Add VBA macro to open/close the Date Picker add-in for Excel for Windows. Read more

25-April-2013 : Add the Date Picker add-in(with week numbers) for Excel for Windows. Read more

22-April-2013 : Update the Date Picker add-in for Excel for the Mac. Read more

21-April-2013 : Add a new page: Copy Folder in Microsoft Office for the Mac with VBA. Read more

17-April-2013 : Add a Date Picker add-in(with week numbers) for Excel 2011 for the Mac. Read more

9-April-2013 : Add a new page to my site with two useful Com add-ins for the Microsoft Office Visual Basic Editor created by Jim Rech. Read more

8-April-2013 : Upload a complete new website layout and for that reason almost all old links are broken. But if correct all broken links direct you to my error page. If you can't find the old page or file you were looking for in the new menu please let me know so I can fix it or direct you to its new location.