Web Query with Excel

mrowe · Mar 25th, 2002, 08:59 AM

Anyone know how to do one of these?

Do I need access to the webserver or is the URL enough? Any examples would be appreciated.

Cheers
Matt

Jack in the UK · Mar 25th, 2002, 11:52 AM

hi =-=

not the most answered question this, worth a check on search.

but you can access excel live on line via hyperlink, and update and save i guess just the same..

trick seems to b to have hype open excel and have autoclose to save, password the openening access is good idea..

Not that im an expert...

Tom Schreiner · Mar 25th, 2002, 06:55 PM

Depends on how page is displayed
Go to any web page that contains frequently changing data like a weather service or time/clock , ect...
Experiment with these...
Right click on the wegpage and view source to capture the tables you need.
It is actually quite simple...
Tom

mrowe · Mar 26th, 2002, 12:59 AM

Ok, so let's say I have a stock tickler for example - what part of the source code do I need to include in the web query?

Mar 25th, 2002, 11:52 AM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	hi =-= not the most answered question this, worth a check on search. but you can access excel live on line via hyperlink, and update and save i guess just the same.. trick seems to b to have hype open excel and have autoclose to save, password the openening access is good idea.. Not that im an expert... __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 25th, 2002, 08:59 AM	#1
mrowe Board Regular Join Date: Feb 2002 Posts: 232	Anyone know how to do one of these? Do I need access to the webserver or is the URL enough? Any examples would be appreciated. Cheers Matt

Mar 25th, 2002, 06:55 PM	#3
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Depends on how page is displayed Go to any web page that contains frequently changing data like a weather service or time/clock , ect... Experiment with these... Right click on the wegpage and view source to capture the tables you need. It is actually quite simple... Tom

Mar 26th, 2002, 12:59 AM	#4
mrowe Board Regular Join Date: Feb 2002 Posts: 232	Ok, so let's say I have a stock tickler for example - what part of the source code do I need to include in the web query?