Pre-defined formats (Repost)

R

Ronald Dodge

The first person that responded to my last post initially thought I meant
going into the control panel and either get or set the code in there
manually until it read the VBA part and realized that is not what I wanted.

Original post:

How do I get the format of the pre-defined formats via VBA?

Example, on one computer, the pre-defined format for "Short Date" may be
"MM/DD/YYYY" (US Version) while on another system, it may be "DD/MM/YYYY"
(UK Version)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Select query with date range format issue 3
Date format error 10
importing ambiguous dates 4
Default date format (with shortcut keys) 2
A date problem with more than 10 years 6
Date format error with CSV file 6
displaying dates in UK format 10
getting the system date format with vba 1

Top