Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Getting the Date Format Being Used By The Operating System And Exc

Hi,

I wanted to know how within my VBA code I would be able to retreive the date
format being used by the OS and Excel, so I could use this to format my dates.

Thanks

Sunnous
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,440
Default Getting the Date Format Being Used By The Operating System And Exc

I don't know how to get the string, but there are several named Date
Formats, like "Long Date", Medium Date" and "Short Date"

--
Kind regards,

Niek Otten

"Sunnous" wrote in message
...
Hi,

I wanted to know how within my VBA code I would be able to retreive the
date
format being used by the OS and Excel, so I could use this to format my
dates.

Thanks

Sunnous



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
operating system not configured to run excel gmoty Excel Discussion (Misc queries) 1 April 14th 06 06:33 AM
running a macro on a different operating system Jez[_6_] Excel Programming 3 August 25th 05 08:03 PM
Find out Operating System Mohan[_2_] Excel Programming 5 January 16th 04 08:36 PM
Operating system Don Guillett[_4_] Excel Programming 0 September 10th 03 04:43 PM
Operating system Stephan Kassanke Excel Programming 0 September 10th 03 04:42 PM


All times are GMT +1. The time now is 01:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"