Thread: Retrieving short system date format in VBA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RoccoCoetzee RoccoCoetzee is offline
external usenet poster
  
Posts: 5
Default Retrieving short system date format in VBA
Hi

Can someone please help me retrieving the system short date format (I
presume its from local)

I have managed to do that from Visual Studio (VB) with the following line.

SystemShortDateFormat =
System.Globalization.CultureInfo.CurrentCulture.Da teTimeFormat.ShortDatePattern

How do I accomplish this in VBA?

--
Rocco Coetzee
Reply With QuoteReply With Quote