VBA: change regional settings > date format with

  • Hi all,


    I need change the system regional settings > date format from mm-dd-yyyy into yyyy-dd-mm when opening my workbook and return into original values when done.


    Who knows the VBA code for changing the regional settings for date?


    Mathijs - The Netherlands

  • I think the API call might provide me with the needed solution.


    I will post a new topic on calling Windows API in VBA (since I don't have any experience with that eiter)


    Thanks for the suggestion!


    This problem was solved by weasel under my new topic: VBA: Windows API call in VBA

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!