PDA

View Full Version : VBA - Format with lanuage change



rob0923
06-02-2010, 10:22 AM
Hi,

I have a VBA program that is automatted to transfers information from Excel to Word. I have know issues with the program itself.

I am using a English based PC (Regional settings are set to U.S. settings) What I would like is to keep the system information the same, but have the information displayed in French after the transfer is complete.

Is there any way to over right the Regional settings and have this following display in French. Please see below for the code.

[$C0C] is the information excel uses to format the cell dates from English to French in long date formats.

Thanks in advance!



With objdoc.Bookmarks

.Item("date").Range.InsertAfter Format((date), "[$C0C]dddd d mmmm yyyy"

End With