Macro to Change System Date format?

[groundin]

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

[JosephP]

sure is but it's not good practice

[groundin]

Noted. Any way you could enlighten me on how?

[JosephP]

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?

[groundin]

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.

[JosephP]

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