alpignolo
09-01-2013, 11:09 PM
Hello,
I need to convert a date string like:"15 march 2012" into an actual date using vba.
I know there is the function datevalue, but it doesn't work in my pc because I have an italian version of excel and it doesn't recognize the word march.
my question is if it exists a way to use datevalue independently from the environmental international settings (e.g to instruct vba that the date string is in english/italian/german....).
thank you in advance
I need to convert a date string like:"15 march 2012" into an actual date using vba.
I know there is the function datevalue, but it doesn't work in my pc because I have an italian version of excel and it doesn't recognize the word march.
my question is if it exists a way to use datevalue independently from the environmental international settings (e.g to instruct vba that the date string is in english/italian/german....).
thank you in advance