Newbi...Help...URGENT

[beginning_excel]

Hi ALL:
I am a total newbie.

I am trying to develop a worksheet that takes values from a A1 to
A10 and displays a values in a B1-B10. (These A1-A10 are parameters to
the URL). The criteria is that the values should be loaded from a
particular field from a webpage.

I tried WEBQuery but it is not appropriate for my use. coz... I
cannot have additional worksheets and I cannot write 10 webqueries.
There should be only one worksheet and macros are allowed.

Please help.... what are the options and any sample code to
start..??

Thanks in advance

 

[beginning_excel]

anybody out there....plz help

 

[gls858]

anybody out there....plz help

You may get a better result if you post an example of
the data and explain in detail what you would like to do.

gls858

 

[beginning_excel]

let me explain what I need:
I need to open a URL (http://www.xyz.com/test.asp?var=xyz)
Here xyz takes 10 values. These values are present in excel sheet fro
A1-A10.

Now for each of these xyz (A1-A10) values a new webpage outpu
results.

There are many tables in the webpage. I need to take data from on
particular table, one particular td-element. When I use webquery th
required value always coming into AE4 cell. So I need to display thi
Value in B1.

At present for A1-A10 there are 10 webqueries resulting 10 sheet
(Sheet1-Sheet10) and from AE4 value I am populating Values to B1-B10.

The requirement is that We dont want all these temporary sheets. I nee
to write a macro to do the job. When the excel file is opened, based o
the values in A1-A10, B1-B10 values should be pulled from the web an
populated.

Plz hel

 

[beginning_excel]

can anyone help(sample code) with reading a webpage into a string.

 

[hoyt]

it may be a possibility to copy the data and then to use the paste special
function:-
paste/link/data.
similar to how you would link an excel sheet to microsoft project for
instance.