Thread: Retrieving short system date format in VBA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default Retrieving short system date format in VBA
Try
Formatdatetime(date,vbShortDate)

If this post helps click Yes
---------------
Jacob Skaria


"RoccoCoetzee" wrote:

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