Excel cell as a string

[ICANSEEYOU7687]

Sorry if this is a silly/stupid question, but I was curious how to do this.

I am trying to check dates in an excel column to get usage statistics, and the date is formatted like MM/DD/YY. I would like to pull this out as a string, and separate this into 3 variables for month, day, and year to be able to do some basic calculations on.

Is there an easy way to do this?

Thanks

[jdelaney]

use the _Excel* functions to open, read, and then you can do a string split, or regular expression to create an array with your needed data...excel will return a standrard format, regardless of the visual formatting on the spreadsheet (the date, that is) *fairly sure

Edited August 31, 2012 by jdelaney

[ICANSEEYOU7687]

Worked! Thanks, I havent used autoit in a while and im a bit rusty.

Thanks!