Daily posts of Excel tips…and other stuff
Author Archive
Hi all
Post Updated : 28-April-2013
I upload a Date Picker add-in based on John Walkenbach’s Date Picker on my site for the Mac and Windows.
This Date Picker have local Day letters in the header and also local Date formats in the format dropdown and have a option to use 3 week number systems(also ISO weeks).
Windows version :
http://www.rondebruin.nl/win/addins/datepicker.htm
Mac version :
http://www.rondebruin.nl/mac/addins/datepicker.htm
Have a nice day
Hi all
VBE Bookmarks/Copy buffer and Tools>References Enlarger Com Add-ins
http://www.rondebruin.nl/win/addins/vbeaddins.htm
When I create this new page on my site about two very nice com add-ins from Jim Rech I found out that if you want to install them on a machine with Office 2013 you are missing a dll file that you need if you want to register one of the com add-ins. Read the info on the page how you can download and register the missing dl so you can install the add-ins also in 2013 .
Regards Ron
Hi all
I like to share the release of this new Mac Excel add-in with you all. After many days of hard work I have upload the first Mac version of the very popular Excel for Windows Add-in “Power Utility Pak” from John Walkenbach on my site.
Power Utility Pak for the Mac, Add-in Tools for Excel 2011
You can also use this link from John’s site to go to the Add-in
The Spreadsheet Page – PUP/Mac Home
As a bonus I also add my mail add-in to the collection. Please give feedback good or bad so I can make this product error-free and accurate.
Use the mail address that you find in the PUP About option in the menu if you want to report bugs or want to give feedback.
Thanks
Hi all
Like a lot of other things in VBA in Office 2011 Dir is not working the same as in Windows.
Together with a great Apple Scripter DJ Bazzie Wazzie I create a VBA function that you can use instead. You can download a file from my site so you can test it.
http://www.rondebruin.nl/mac.htm#Loop
You call the function with one line of code :
Call GetFilesOnMacWithOrWithoutSubfolders(Level:=1, ExtChoice:=0, FileFilterOption:=0, FileNameFilterStr:=”SearchString”)
‘Level : 1= Only the files in the folder, 2 to ? levels of subfolders
‘ExtChoice : 0=(xls|xlsx|xlsm|xlsb), 1=xls , 2=xlsx, 3=xlsm, 4=xlsb, 5=csv, 6=txt, 7=all files, 8=(xlsx|xlsm|xlsb), 9=(csv|txt)
‘FileFilterOption : 0=No Filter, 1=Begins, 2=Ends, 3=Contains
‘FileNameFilterStr : Search string used when FileFilterOption = 1, 2 or 3
You can add also more extensions or replace it for word extensions or so.
Thanks, feedback good or bad is welcome
Hi all
For the Mac users in this forum ?
Check out this Mail add-in for Excel 2011 for the Mac
For more info and download visit the page below:
http://www.rondebruin.nl/MacMail/rdbmailmac.htm
Hi all
I think this is the fix if you want to create a Outlook mail with a signature with or without a picture in it.
http://www.rondebruin.nl/mail/folder3/signature.htm
I hope it is working OK for everybody, if not mail me or post it here.
Other suggestions are also most welcome
Have a great day
Hi all
FYI
A few weeks back I start working on my first Mac, and I must say I love the OS but there is a lot of work to do in Office for the Mac.
My idea is to go through all my webpages and see if I can make the VBA code also working in Excel 2011.
I start this problem page
http://www.rondebruin.nl/mac.htm
I also add VBA code examples last week to mail from Excel 2011 with Apple Mail and Outlook 2011.
If you have problems with Excel on a Mac post it here, maybe I can check it out and find a workeround for it.
Ron de Bruin
http://www.rondebruin.nl/tips.htm
Hi all
FYI, I add this page last weekend to my site :
Enable or Disable custom Ribbon buttons in Excel 2007-2010
http://www.rondebruin.nl/enable.htm
I also have a page for hiding and displaying :
Hide or Display Custom Ribbon Tab/Group/Control with getVisible
http://www.rondebruin.nl/hidevisible.htm
If you have suggestions or good or bad comments let me know(I am no expert)
Ron de Bruin
http://www.rondebruin.nl/tips.htm
Hi all
There is a common problem when you are working with the Ribbon with RibbonX and VBA.
The ribbon object (which is initialized when Excel loads your file) can loose its reference
to the ribbon, which means your code can no longer tell Excel to update your ribbon customizations.
There is simply no easy built-in way to recover the handle to the Ribbon when there are problems
in or with your code. The only way to fix it is to close reopen your workbook, not a very user friendly way.
But MVP Rory Archibald came up with a great idea in a post in the MrExcel forum.
I created a example workbook based on Rory’s idea on the following page :
loss of state of the global IRibbonUI Ribbon object
http://www.rondebruin.nl/ribbonstate.htm
If you have suggestion or comments let me know so I can add it to the page
Ron de Bruin
http://www.rondebruin.nl/tips.htm
FYI
Excel MVP Dennis Wallentin allow me to publish his Lotus Notes examples on my site.
Great to have them online again so I can point Lotus Notes users to them when they mail me.
http://www.rondebruin.nl/notes.htm
Have a nice day
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
