[krofox]

This is my first visit. I am new to vb. I need some help.
I have a site from where i can import data to excel. I need help
Data comes in a column . I need to put the data in different column. and every time when the data is refreshed and imported from the website it would be arranged in the same format. That is in different column.

Thanks

[shabbir]

Are you exporting the data or downloading some precreated excel files ?

[krofox]

Thanks Shabbir,

Actually , i would be importing the data file from Web site . which are in a single column.

To make clear

2009,2,13,1,1,72.32
1) Put the datas in different column

2) here ......
First in the year
Second is the month
Third is the date
Fourth is the first hour of the day
Fifth is the first five mins of the hour
Sixth is the value

3) Change the fifth column into actual mins

4) Fourth and Fifth column should look like....01:05 in a single column..

4) And everytime the data refreshes ...it would come in the above format with the No:3 and No:4 condition.

Thanks ..

[shabbir]

Then you have to code so that it reads the data and formats accordingly.