Help to modify the query?

E

Eric

Does anyone have any suggestion on how to do it in excel?

There is the format for the macro query.
qryConnect = "URL;http://www.myurl.com/filename.html"
For example,
qryConnect = "URL;http://www.myurl.com/john.html"
qryConnect = "URL;http://www.myurl.com/1.html"

There is a list of file names on column A under Lists worksheet.
Does anyone have any suggestions on how to retrieve the character on column
A under worksheet lists and insert into the query in order to do the
following tasks?

I would like to load a list of web links into Temp worksheet, after the
first link is loaded from cell A1 under Lists worksheet, then retrieve the
value in cell A10 under Temp worksheet and paste this value into B1 under
Lists worksheet. After that,

repeat for the next web links ...

after the second link is loaded from cell A2 under Lists worksheet, then
retrieve the value in cell A10 under Temp worksheet and paste this value into
B2 under Lists worksheet.

repeat for the next web links ...

after the third link is loaded from cell A3 under Lists worksheet, then
retrieve the value in cell A10 under Temp worksheet and paste this value into
B3 under Lists worksheet.

repeat for the next web links ...

Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help on coding? 2
Please help on coding the macro. 0
Please help on coding 0
How to retrieve data from web link? 2
Can anybody help on macro please? 8
How to fix the coding? 0
How to re-fresh the import links if it fails? 1
How to load a list of web links into specific worksheets? 0

Top