Hi all

In a thread in Excel Programming Bob Phillips and I came up with this.
The two examples on the site add the Outlook signature below your message
If you create a signature in Outlook it will save three files (HTML, TXT and RTF) into

C:Documents and Settings” & Username & “Application DataMicrosoftSignatures

I used Dick’s Boiler function to read the files (thanks Dick).
There is an example for a plain text and html signature.

More info on the webpage below
Insert Outlook Signature in mail

Ron de Bruin
http://www.rondebruin.nl/index.html

Hi all

If you have Multilingual User Interface (MUI) Pack of Office maybe you like this add-in.

This download allows you to identify and change language, keyboard, and regional settings for Microsoft Windows, Microsoft Internet Explorer, and Microsoft Office 2003 programs with a single tool. You can compare the settings of these programs and make changes as appropriate.

http://www.microsoft.com/downloads/details.aspx?FamilyId=CC37E08C-1019-4AE8-A258-0D5412876DEC&displaylang=en

Have fun

Ron de Bruin
http://www.rondebruin.nl

Hi all

On my site I have code to zip/unzip with WinZip, but many people asked me if it is not possible
to do the same with the default Windows XP zip program.
Finally I found a way with VBA to zip with the default Windows XP zip program.

I add this page to my site with a few examples.
http://www.rondebruin.nl/windowsxpzip.htm

Have fun with it

Regards Ron de Bruin
http://www.rondebruin.nl

Hi all

I use a new Microsoft keyboard for a few months now and it is working great.
The only thing I donít like that they have dual function F-keys and by default
they don’t behave like normal F-keys.

For example Alt-F11 to open the VBE is not working by default.

On the right of the F12 there is a key (F Lock) to enable normal F-Key behavior.
The problem is that you must press this key every time you reboot your computer.

Excel MVP Gord Dibben pointed me to the site of MVP Jason Tsang.
He has a couple of .REG files that will allow you to reverse the default behaviour of the F Lock key or disable it.

One will change the default to “Off”.
http://mvps.org/jtsang/flock.html

The other will eliminate the F Lock feature totally
http://mvps.org/jtsang/flock-e.html

Regards Ron de Bruin
http://www.rondebruin.nl

Hi all

I have upload Easyfilter 2.1 Beta to my site with a Color tab.
It is not working on CF colors (this is the next step).
You can filter on Fill, Font colors and on bold cells.

Comments good or bad are welcome about this Beta version.
You can find it here (on the bottom of the page)
http://www.rondebruin.nl/easyfilter.htm

Ron de Bruin

Hi all

Together with Norman Harker and the late Frank Kabel I have create EasyFilter 2.0.
This version have a special Date tab with a lot of Date filter options.
I hope it is useful for a lot of Excel users.

This Version of EasyFilter is dedicated to the memory of Excel MVP Frank Kabel.
We will miss him very much.

You can download it here
http://www.rondebruin.nl/easyfilter.htm

Please read the Superb User Guide made by Norman Harker

Ron de Bruin
http://www.rondebruin.nl/

If you use week numbers in your workbooks then be aware that there are different
week number systems in use in the world.
If you order for example lingerie from Paris for your wife and want to have it in week 5 (2005)

Note: WEEKNUM is an Analysis ToolPak function

Excel WEEKNUM (first day Sunday): 23-jan-29-jan
Excel WEEKNUM (first day Monday): 24-jan-30-jan
ISO week number (first day Sunday): 31-jan-6-feb

You see that you have a big problem

On Chip Pearson’s site you can find all the information you need about week numbers.
http://www.cpearson.com/excel/weeknum.htm

But Norman Harker and I created a week calendar file that might be usuful.
http://www.rondebruin.nl/weeknumber.htm

It shows you all the dates and week numbers from a certain year on one printable page.
There is a separate sheet for the following week numbering systems :

1) ISO Week numbering: Week 1 starts on Monday of the week with the first
Thursday of the Calendar Year.

2) Excel WEEKNUM function (optional second argument of 1 (default)). Week 1
starts 1-Jan with subsequent weeks starting on a Sunday and final week ending on 31-Dec.

3) Excel WEEKNUM function (optional second argument of 2). Week 1 starts
1-Jan with subsequent weeks starting on a Monday and final week ending on 31-Dec.

4) Simple week number. Week 1 starts on the first day of the year.

I will release a new version of my EasyFilter add-in next week with a Date tab with
options to filter on week numbers, weekdays, months, years, quarters,….)

Ron de Bruin
http://www.rondebruin.nl/

Hi all

If you are using Office 2003 you might be interested in the new help files for VBA

Office 2003 Editions : Excel VBA Language Reference
http://www.microsoft.com/downloads/details.aspx?familyid=2204a62e-4877-4563-8e83-4848dda796e4&displaylang=en

Note : The text on the website is not correct.
The CHM file is named Vbaxl10.chm and not Vbaxl11.chm
Very strange that they use the Excel 2002 version number.

Ron de Bruin