External data still........

kurtpackard · Apr 5th, 2002, 11:30 AM

Hi, I still cannot figure out how to pull data from the web without having to insert the complete URL. I want to reference PART of the URL from a cell I.E. Cell A1 to Cell A1000. I want it to do it automatically, as I have thousands of numbers to track on the internet and they each have their own web page.

Thanks,

Kurt

Jay Petrulis · Apr 5th, 2002, 11:49 AM

Quote:

On 2002-04-05 10:30, kurtpackard wrote:
Hi, I still cannot figure out how to pull data from the web without having to insert the complete URL. I want to reference PART of the URL from a cell I.E. Cell A1 to Cell A1000. I want it to do it automatically, as I have thousands of numbers to track on the internet and they each have their own web page.

Thanks,

Kurt

Hi Kurt,

I am not sure I follow you, but are you going to append the specifics to a certain set website (i.e you have the main part of the URL as the constant and the detailed, secondary pages on the worksheet)?

If so, could you use something like this in your loop...?

setstring = (your base URL)

For x = 1 to 1000
yourstring = setstring & Cells(x,1)

do something with your string

next x

This may be of some use.

Regards,
Jay

jfuoti · Apr 5th, 2002, 11:50 AM

Try Downloading the Excel Web Connectivity Kit from http://office.microsoft.com/downloads
it will give you a detailed explanation of writing queries and examples

kurtpackard · Apr 5th, 2002, 01:12 PM

I am sorry I am not being very clear. I have been using Excel for a long time, but I have only used it for the simple stuff. Let me try to explain.

I have a spreadsheet I created off of a shipping data base that in Colum A has all of the tracking numbers. I have used the extract data function sucessfully for a single tracking number, say in colum A1. What I want to do is have excel automatically track the numbers from the web. I really do not care how it gets done, as long as it gets done. Someone sent me some code, but I am not really clear on where to put it or how to implement it. I will down load the connectivity kit when I get home tonight and try that. If there are any books I could buy please let me know.

Thank you,

Kurt

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

Apr 5th, 2002, 11:30 AM	#1
kurtpackard New Member Join Date: Apr 2002 Posts: 3	Hi, I still cannot figure out how to pull data from the web without having to insert the complete URL. I want to reference PART of the URL from a cell I.E. Cell A1 to Cell A1000. I want it to do it automatically, as I have thousands of numbers to track on the internet and they each have their own web page. Thanks, Kurt

Apr 5th, 2002, 11:50 AM	#3
jfuoti New Member Join Date: Mar 2002 Posts: 48	Try Downloading the Excel Web Connectivity Kit from http://office.microsoft.com/downloads it will give you a detailed explanation of writing queries and examples

Apr 5th, 2002, 01:12 PM	#4
kurtpackard New Member Join Date: Apr 2002 Posts: 3	I am sorry I am not being very clear. I have been using Excel for a long time, but I have only used it for the simple stuff. Let me try to explain. I have a spreadsheet I created off of a shipping data base that in Colum A has all of the tracking numbers. I have used the extract data function sucessfully for a single tracking number, say in colum A1. What I want to do is have excel automatically track the numbers from the web. I really do not care how it gets done, as long as it gets done. Someone sent me some code, but I am not really clear on where to put it or how to implement it. I will down load the connectivity kit when I get home tonight and try that. If there are any books I could buy please let me know. Thank you, Kurt