A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Linking to specific tables in web data



 
 
Thread Tools Display Modes
  #1  
Old August 10th, 2008, 08:32 AM posted to microsoft.public.excel.links
bleachlizard
external usenet poster
 
Posts: 1
Default 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  
Old October 23rd, 2008, 09:57 PM posted to microsoft.public.excel.links
jasonfalbo
external usenet poster
 
Posts: 1
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:07 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.