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!