TextToColumns > MDY

Hi Everyone,

I'm trying to do the following in VB.

Data > TextToColumns > Delimited > 'Delimiters Doesn't Matter' > Column Data Format = Date: MDY.

I recorded a macro manually doing this and came up with the following:

Please Login or Register  to view this content.

This works when I do it manually, but not when part of a macro.

Can anyone help?

Thanks
Dave