Using array to transfer data of different data types to worksheet

I have a macro where i open up a file. I then test to see if the data in the file is "good". If it is good then i transfer the data to another file. Then i open up another file and do it again.......repeating this for every file in a given directory.

RIght now i take all the data that i want to transfer and store it into a single string array. What i am finding is that i may not want to do this. The data i am transferring has many different data types such as dates, text, numbers........etc. SInce i am dealing with data sent to me from another country i think converting dates to strings and then putting string into my sheet is causing a problem.

So i want to know is there a way of having an array with different data types?

When doing it the following way you will keep the datatypes

Please Login or Register  to view this content.