Hi,

I like to write a macro that pasts csv data from the clipboard. The data containt dates and times.
If I just past the data and use the text to columns feature the dates are store as text and not as dates.
If I use paste special unicode text it is ok.
So far so good...
Now I wanted to record a macro for this, while recording everything goes great, but when I run the macro I have the same problem with the dates.

The data looks like:
Please Login or Register  to view this content.
where the first data is the date/time and the others values of our solarsystem.

This is the macro I allready have:
Please Login or Register  to view this content.
Now, if I paste special the data myself and then run the macro WITH the remarks on line 2 and 3 everything is good.
But when I try to do the paste special by the macro it gets screwed up. I can see that because the date/time is then aligned left instead of right.
After that, another program called sunnyreport, reads the xls file to create graphs. If the date/time isn't good the program doesn't work.

CSV data can be found at http://sdc.cindyenguy.be
XLS files are at http://sunnyreport.cindyenguy.be/xls/

Thanks