Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
web crawler
Hi, I would like to extract data from a certain website, how do I go about doing that? can I do it with a macro? if so, is there a tutorial on it somewhere? Please let me know. Thanks very much. -- owl527 ------------------------------------------------------------------------ owl527's Profile: http://www.excelforum.com/member.php...o&userid=20916 View this thread: http://www.excelforum.com/showthread...hreadid=487478 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
web crawler
See if this works for you: 1)Open a browser and go to the website. 2)Copy the URL (to notepad for safekeeping...just in case) 3)Switch to Excel 4)DataImport External DataNew Web Query 5)Paste your URL into the Address field in the New Web Query window 6)Click on the section of data you want to retrieve 7)Click the [Import] button 8)Select where you want to data to reside...and you're done. After that...to refresh the data, just: Right click on the data and select "Refersh Data" Does that help? Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=487478 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
web crawler
hi, after I got to Data- there's only "Get External Data" then run web query/ run database query/ create new query. I can't find the address field in any of these option, please help explain again.... thanks very much for your help. -- owl527 ------------------------------------------------------------------------ owl527's Profile: http://www.excelforum.com/member.php...o&userid=20916 View this thread: http://www.excelforum.com/showthread...hreadid=487478 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
web crawler
I'm running Excel 2002 SP3 on XP Pro. Evidently, there are some phrasing differences from version to version. So, assuming (yeah, I know) that the functionality will be similar, try: DataGet External DataRun Web Query and see where that takes you. Post back to let us know how you fared. Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=487478 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
web crawler
after I got in there, it brings me to a "Run Query" Window. I tried pasting the URL in the field and it gives me an error message saying the query is not found. How should I go about doing this? I have attached a screen shot here. please help. Thanks. +-------------------------------------------------------------------+ |Filename: excel.jpg | |Download: http://www.excelforum.com/attachment.php?postid=4062 | +-------------------------------------------------------------------+ -- owl527 ------------------------------------------------------------------------ owl527's Profile: http://www.excelforum.com/member.php...o&userid=20916 View this thread: http://www.excelforum.com/showthread...hreadid=487478 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
web crawler
A few questions: What version of Excel are your running? What's that "Get more web queries.iqy" shown in the file you posted? -Is that something you can use/customize? That's all I can think to ask right now. Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=487478 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|