1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

vb code data refreshing

Discussion in 'Visual Basic ( VB )' started by krofox, Feb 15, 2009.

  1. krofox

    krofox New Member

    Joined:
    Feb 15, 2009
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    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
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,292
    Likes Received:
    365
    Trophy Points:
    83
    Are you exporting the data or downloading some precreated excel files ?
     
  3. krofox

    krofox New Member

    Joined:
    Feb 15, 2009
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    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 ..
     
  4. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,292
    Likes Received:
    365
    Trophy Points:
    83
    Then you have to code so that it reads the data and formats accordingly.
     

Share This Page