Home |
Search |
Today's Posts |
#1
|
|||
|
|||
External Data from Web
I have built a code which loops through a list of URLs, scrapes data from a specific table on that page, and then repeats the process with the next URL until finished.
This was working up until today. Now, suddenly I am seeing a pop-up each time I try to load the next URL: "File could not be accessed. Try one of the following: - Make sure the specified folder exists - Make sure the folder that contains the file is not read-only - Make sure the file name does not contain any of the following characters: < ? [ ] : | * - Make sure the file/path name does not contain more than 218..." here is a sample URL http://espn.go.com/nba/playbyplay?ga...31025&period=0 I realize it has a "?", but it was working earlier today. I looped through 50 URLs, before the code errored, and now I can't get it working. I even went back and tried to manually create the External Data Connection, but even that is not working. Any thoughts? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
External Data from Web
dutchpancake wrote:
I have built a code which loops through a list of URLs, scrapes data from a specific table on that page, and then repeats the process with the next URL until finished. This was working up until today. Now, suddenly I am seeing a pop-up each time I try to load the next URL: "File could not be accessed. Try one of the following: - Make sure the specified folder exists - Make sure the folder that contains the file is not read-only - Make sure the file name does not contain any of the following characters: < ? [ ] : | * - Make sure the file/path name does not contain more than 218..." here is a sample URL http://espn.go.com/nba/playbyplay?ga...31025&period=0 I realize it has a "?", but it was working earlier today. I looped through 50 URLs, before the code errored, and now I can't get it working. I even went back and tried to manually create the External Data Connection, but even that is not working. Any thoughts? Post your code. -- Base ten numbering seems to be all the rage these days, so I went with that. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
External Data Warning Message - I have No External Data in wrkbk | Excel Discussion (Misc queries) | |||
Getting External Data based on criteria insde of the external data | Excel Discussion (Misc queries) | |||
Excel Macro for taking data external data and populating it on a sheet and deleting unwanted data | Excel Programming | |||
updating external data sheet causes loss of data on linked pages | Excel Worksheet Functions | |||
Need advice : consolidating data from multiple CSV files in Excel - External data handling | Excel Programming |