循环马可，你的网址 [英] Looping Marco thur url

问题描述

您好，我已经创建了一个可以访问网站并提取数据的marco。通过网络查询。

我希望它能够循环遍历包含所有网址的列。并停在包含网址的最后一行...


SO ....

列K的URL从K2开始，这些网址来自，因为rss feed

Hello, I have create a marco that will go on a site and extract data. thru a web query.
I would like it to keep looping through the column that has all the urls. and stop at the last row containing a url...

SO....
Column K has the URLS starting at K2 these urls come in because a rss feed

展开 | 选择 | Wrap | 行号

推荐答案

这将循环通过col：

This will loop through the col:

展开 | 选择 | Wrap | < span class =codeLinkonclick =LineNumbers（this）;>行号

感谢Guido，它完美地循环但我希望能够做到一次它循环遍历第一个URL，它打开Web查询并导入一些数据并将其转换到列OY并一直反复执行这些步骤，直到它到达最后一个条目。

i希望显示我的意思，但这是一个非常有信心的名单清单，我不能放在这个网站上......

但如果这是可以做Guido，我真的非常感谢帮助...

Thanks Guido, It loops pefectly but i would like to be able to do once it loops through the first url it opens web query and imports some data and transposes it across columnns O-Y and keeps doing these step over and over until it reaches the last entry.
i would like to show what i mean but this is a very confidental list of names cleint that i can not put on this site...
But if this is something that can be done Guido, I really do appreciate the help...

只需在我添加的3行中编写代码：


......

''做事情

......


如果您需要帮助，可以你是否附上了像Piet，Jan，......和数据这样的虚构名字的工作簿？

只是看看工作表的结构，在哪个地方以及需要添加数据的地方？

请记住，我不能使用网页查询？或者好吗？

Just write your code in the 3 lines I have added with :

......
''Do things
......

If You need help, can''t you attach a workbook with fictive names like Piet, Jan, ... and data ?
Just to see the structure of the sheet, what is on which place and where data need to be added?
Keep in mind that I can''t use the web query ? or well ?

这篇关于循环马可，你的网址的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！