+ Reply to Thread
Results 1 to 6 of 6

Macro to Change System Date format?

  1. #1
    Forum Contributor
    Join Date
    11-25-2012
    Location
    Edmonton, Alberta
    MS-Off Ver
    2010
    Posts
    146

    Macro to Change System Date format?

    is it possible to create a macro that would be able to change the system date format of computer it is running on?

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Macro to Change System Date format?

    sure is but it's not good practice
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Forum Contributor
    Join Date
    11-25-2012
    Location
    Edmonton, Alberta
    MS-Off Ver
    2010
    Posts
    146

    Re: Macro to Change System Date format?

    Noted. Any way you could enlighten me on how?

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Macro to Change System Date format?

    I'll tell you you need the setlocaleinfo api

    how about you tell us why you think you need to mess with the user's settings?

  5. #5
    Forum Contributor
    Join Date
    11-25-2012
    Location
    Edmonton, Alberta
    MS-Off Ver
    2010
    Posts
    146

    Re: Macro to Change System Date format?

    Sure, I have a workbook that goes to our workers, this workbook sends an automated text file in an email. This text file is then picked up and imported into an online "app". When the local time settings aren't USA it imports the wrong dates and messes it up. Our workers aren't always the same people and often use different computers (day shift and night shift). The easiest solution is to have all the local dates the same so it is consistent to the importing program. I will PM you login details to our online app so you can see real-world what it does.

  6. #6
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Macro to Change System Date format?

    sounds like you just need to change the program that creates the text file not change the system settings

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro to change date format
    By drobinson782001 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-04-2013, 08:09 PM
  2. [SOLVED] Macro to change date format
    By vijanand1279 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-30-2013, 02:16 PM
  3. Macro to change date value from one date format to another date format
    By RG12 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-23-2013, 04:51 AM
  4. Macro to change date format
    By MalibuLX3 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-21-2013, 09:22 PM
  5. Replies: 7
    Last Post: 11-18-2012, 02:28 PM
  6. Change system date with VBA
    By RedWing in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-31-2011, 11:38 AM
  7. Change system date and time format
    By elcaris in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2008, 03:34 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1