Question: how to change date format to yyyy-mm-dd in vba?
Answer: Start menu, control panel, region and language, format to "English (United Kingdom)" and then set the short date to "dd/MM/yyyy" and say apply and Ok.