LakhaniRahul
03-20-2003, 10:16 PM
Hi,
I have to develop an application in VB that scans an excel file (abc.xls). This excel file contains an entire column full of http links. The application should take the data from each of these http links one by one and put the data into another excel file.
It can be assumed that each of the http links is a single webpage with the data on it organized in a 2 column table in the following format
Item1 Blah
Item2 Foo
Item3 Bar
Item4 Glub
hence this data has to be picked up and stored in another excel file in separate colums(Column 1 = Item 1, Comumn 2 = Item 2,........)
Can anyone point me in the right direction. Is this even possible in VB?. If so, then how can i get started on this.
Any help or advice is highly appreciated
Thankyou very much
Rahul
I have to develop an application in VB that scans an excel file (abc.xls). This excel file contains an entire column full of http links. The application should take the data from each of these http links one by one and put the data into another excel file.
It can be assumed that each of the http links is a single webpage with the data on it organized in a 2 column table in the following format
Item1 Blah
Item2 Foo
Item3 Bar
Item4 Glub
hence this data has to be picked up and stored in another excel file in separate colums(Column 1 = Item 1, Comumn 2 = Item 2,........)
Can anyone point me in the right direction. Is this even possible in VB?. If so, then how can i get started on this.
Any help or advice is highly appreciated
Thankyou very much
Rahul