In the VBA I tried the following:

MyDate = DateSerial(2004, 7, 30)
MsgBox Format(MyDate, "mmmm yyyy")

it gave me the month and the year in my language (as in the regional options
in windows control panel)
I want to force the result to give me "July 2004" regardless the settings in
the windows.
In a worksheet, I can format such a date with "B1mmm yyyy" to give me what I
want.
But in VBA, the "format" function didn't accept the "B1mmm yyyy" to format
MyDate.
Any ideas?
Thanks in advance