Convert DD/MM/YYYY to MM/DD/YYYY and HH:MM to HH:MM AM/PM

[ALEXJ21]

Hello.

I have a CSV file with 2 rows that have the date in format DD/MM/YYYY and the hour in format HH:MM. I need to grab those values, convert them in MM/DD/YYYY and HH:MM AM/PM and then select those values from a dropdownmenu from a website. The rest is done, but the macro stops somehow here, but I got it done the first part(convert DD/MM/YYYY and choose from a dropdown the value).

Thank you in advance.