If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Linking to specific tables in web data
Greetings, and might I say a hearty hello to new faces. I'm new to this forum, and this is my first post. I have a bit of a dilemma. I know what I want, just not how to get there. I need to dump data from a particular table on several consecutive web pages (html docs declared in a text file and the table has the same id on each page) into consecutive cells. An example shown below: 'table1' is where the data is located on each page. http://asite.com/001.html[table1] -- dump to $A$1 http://asite.com/002.html[table1] -- dump to $A$2 http://asite.com/005.html[table1] -- dump to $A$3 .... .... .... etc. Like I said, all the html documents are declared in a separate text file. So I imagine it would entail assigning a variable to line 1 in the text file, taking that variable and gathering the table1 data from it (which is the part I don't know), dump that to A1, and then reassign the variable to line 2. I know this means a loop statement, and I know how to get the data from the text file. It's getting the data from the table1 on each instance of the variable that's a little perplexing. Then dumping that data to the next cell in the column. Perhaps I just haven't looked hard enough... or maybe I need to take this apart piece by piece and examine it that way, and write the code by pieces first (sorry, going off into my world again). Anyway, I don't want the whole code, I just want an idea of what I might be able to do in this situation. Don't spare the programming jargon either. I know enough about vb to understand what's said. It may help me in the long run anyway. Thanks in advance. -- bleachlizard |
#2
|
|||
|
|||
Linking to specific tables in web data
1. record a macro (webquerymacro) that uses a webquery to get the data from
one website 2. write a second macro (loopingmacro) that loops through file names in your list of websites file 3. in the looping macro thereshould be 3 lines of code... dim websiteURL as string for each URL in sourcefile websiteURL = filename[n] call webquerymacro next from your application use a button to call looping macro to get your results "bleachlizard" wrote: Greetings, and might I say a hearty hello to new faces. I'm new to this forum, and this is my first post. I have a bit of a dilemma. I know what I want, just not how to get there. I need to dump data from a particular table on several consecutive web pages (html docs declared in a text file and the table has the same id on each page) into consecutive cells. An example shown below: 'table1' is where the data is located on each page. http://asite.com/001.html[table1] -- dump to $A$1 http://asite.com/002.html[table1] -- dump to $A$2 http://asite.com/005.html[table1] -- dump to $A$3 .... .... .... etc. Like I said, all the html documents are declared in a separate text file. So I imagine it would entail assigning a variable to line 1 in the text file, taking that variable and gathering the table1 data from it (which is the part I don't know), dump that to A1, and then reassign the variable to line 2. I know this means a loop statement, and I know how to get the data from the text file. It's getting the data from the table1 on each instance of the variable that's a little perplexing. Then dumping that data to the next cell in the column. Perhaps I just haven't looked hard enough... or maybe I need to take this apart piece by piece and examine it that way, and write the code by pieces first (sorry, going off into my world again). Anyway, I don't want the whole code, I just want an idea of what I might be able to do in this situation. Don't spare the programming jargon either. I know enough about vb to understand what's said. It may help me in the long run anyway. Thanks in advance. -- bleachlizard |
Thread Tools | |
Display Modes | |
|
|