 |
Ron de Bruin
|
 |
|
|
Ron de Bruin
|
|
Note : Last update or new added page is on top of this page.
Maybe you must reload the page with Ctrl-F5 to see the updated information on the webpage.
12-March-2022 : Add a Kill line in the code to delete the picture after the mail is created on this page : Mail range as picture in the body of Outlook mail Read More
22-Oct-2021 : Update EasyFilter to version 3.2, changed Date filtering and working correct now in non English systems, Read More
19-Oct-2021 : Update EasyFilter to version 3.1 to fix a bug with loading dates, Read More
10-Oct-2021 : New: EasyFilter is a multi-optioned tool that allows far easier filtering of data, Read More
16-Jan-2021 : Hide, Display and Activate Ribbon Tab/Group with getVisible Read More
2-Jan-2021 : Update ISO Date Representatation and Week Numbering page Read More
21-Dec-2020 : Moved all my Mac content to a new website named macexcel.com Visit macexcel.com
16-Nov-2020 : Date Picker Add-in for Excel for the Mac, version 3.2 is also working in Big Sur Read More
2-Nov-2020 : Read value from Mac Excel Preference file Read More
2-Nov-2020 : SaveSetting, GetSetting and DeleteSetting on Mac Read More
23-Aug-2020 : How to use AppleScriptTask in Mac Office 2016 or higher Read More
16-Aug-2020 : Excel version and Office language settings Read More
16-Aug-2020 : Mac Excel version and Mac Office language settings Read More
13-July-2020 : Tab and Group idMso's of the Mac Excel 365 Ribbon Read More
13-July-2020 : Setup your Mac for Mac Office 2016 or higher update Read More
9-July-2020 : Change built-in groups in the Ribbon in Excel 2007 and up Read More
9-July-2020 : Useful Excel Add-ins, books and ? Read More
2-July-2020 : Update my Hardware and software page. Read More
11-June-2020 : New version of the Date Picker for Mac Excel. Read More
10-June-2020 : StartUp Position UserForm in Win and Mac Excel. Read More
24-May-2020 : Insert Picture on Worksheet with VBA in Mac Office. Read More
26-April-2020 : It still is an issue to date : losing the state of the global IRibbonUI ribbon object. Read More
26-April-2020 : Create and Mail PDF files with Excel 2007 and higher in Windows, update the code to avoid a problem if you also use the before print event. Read More
18-April-2020 : New code examples to mail from Excel 2016 and up with Apple Mail in Catalina, they finally have fixed the signature bug in Catalina that we have from macOS Sierra. Read More
22-Dec-2019 : Save Chart or Chart sheet as JPG file in Mac Excel. Read More
11-Dec-2019 : Date Picker Add-in for Excel 2007 and up for Windows, add VBA code to read the last picked date in the Date Picker so you can use it in your own VBA projects. Read More
9-Dec-2019 : Merge Add-in for Excel 2016 or higher on the Mac. Read More
9-Dec-2019 : Loop through Files in Folder on a Mac (Dir for Mac Excel). Read More
25-Oct-2019 : Mail range as picture in the body of Outlook mail in Windows. Read More
24-Oct-2019 : Use SendUsingAccount in Excel/Outlook 2007 or higher in Windows. Read More
23-Oct-2019 : If you use the mail code for Excel 2016 and up with Mac Mail from my site you must replace the script file from the download with all the examples if you update to macOS Catalina, check out this page. Read More
20-Oct-2019 : If you use the mail code for Excel/Outlook 2016 and up from my site you must replace the script file from the download with all the examples if you update to macOS Catalina, check out this page. Read More
22-Aug-2019 : I update my Backstage page with the idMso of the Home tab that is now in Backstage when your Office 2016 or higher is up to date. Read More
24-March-2019 : I update a few Ribbon pages on my site with the link to the new Office RibbonX Editor created by Fernando Andreu. Read More
15-March-2019 : I update my Mac Dynamic menu for your favorite macros today like I also did for Windows a few months back, now also a option to choose one of the 1671 imageMso icons for the buttons. Read More
7-March-2019 : I update my Windows Date Picker for Excel 2007 and up today, now also possible to use the add-in on a protected sheet with Format Columns not checked. Read More
2-March-2019 : Update: Because of a change in the Dir function and a few other VBA changes in the last updates I have update a lot of code in the files and folders section on my website today (17 pages) : Working with Files and Folders (Mac), more updates will follow. Read More
7-Feb-2019 : Update: Mail from Mac Excel 2016 with Mac Mail 2016, because of a change in the Dir function I have to update my folder check function in my mail examples for Mac Mail. Read More
1-Feb-2019 : Update: Because of a change in the Dir function I have update my folder check function named CreateFolderinMacOffice2016 in a few examples on my site for Mac Excel.
1-Feb-2019 : Update: Also add a Body mail option in my add-in for: Mail from Mac Excel 2016 with Outlook 2016. Read More
1-Feb-2019 : Update: Mail from Mac Excel 2016 with Outlook 2016, because of a change in the Dir function I have to update my folder check function in my mail examples for Outlook. Read More
6-Aug-2018 : New: Mail from Mac Excel 2016 with Outlook 2016 in the body. Read More
6-Aug-2018 : New: Dynamic Menu for your favorite macros in Excel 2007-2016. Read More
16-July-2018 : Add a new idMso for Backstage view, see examples. Read More
17-June-2018 : New version Excel/Outlook mail add-in. Read More
18-May-2018 : New version : Menu for favorite Macros in Mac Excel 2016. Read More
17-May-2018 : Making PDF files with VBA page with new download. Read More
16-May-2018 : Update making PDF files with VBA page with fix for latest Win 10 update. Read More
24-March-2018 : SaveAs and FileFormat numbers in Mac Excel. Read More
11-March-2018 : New : Add-in for inserting sheet templates for Mac Excel 2016. Read More
11-March-2018 : Update : Setup your Mac for Mac Office 2016 script file. Read More
11-March-2018 : Update : Fixed the problem in the mail codes for Mac Excel 2016 and Apple Mail because there where problems in some languages with the boolean I first used to display the mail yes or No. Read More
10-March-2018 : Update : Fixed the problem in the mail codes and add-in for Mac Excel 2016 and Outlook 2016 because there where problems in some languages with the boolean I first used to display the mail yes or No. Read More
15-Jan-2018 : Update : DatePicker for Excel 2016 for the Mac. Read More
15-Jan-2018 : Update : Mail code for Excel 2016 for the Mac. Read More
28-Dec-2017 : Update : FileName Lister Add-in for Excel 2016 for the Mac. Read More
27-Dec-2017 : Update : Menu for favorite Macros in Mac Excel 2016. Read More
17-Dec-2017 : Update : Setup your Mac for Mac Office 2016. Read More
21-Nov-2017 : Update : Mac Excel version and Mac Office language settings. Read More
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.