| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
downloading from the internet
Hello Excel Help World- I have a list (in excel) of webpages that I want to open and bring into excel. So, I recorded a macro using the Data/Import New Data/New Web Query tool. In VB, I am putting a for loop around this command to successively do all the websites in my list. Since the websites change, I declare a variable (webSite) and set it equal to the cell described by the counter in the for loop. Then, when the recorded macro calls the website, I put in webSite.Value. However, this is giving me a syntax error. Any ideas??? Much thanks for any help you can offer on my problem! Dan Marks -- DanMarks ------------------------------------------------------------------------ DanMarks's Profile: http://www.excelforum.com/member.php...o&userid=31127 View this thread: http://www.excelforum.com/showthread...hreadid=507938 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
downloading from the internet
the code and exact error message might help? -- CFD ------------------------------------------------------------------------ CFD's Profile: http://www.excelforum.com/member.php...o&userid=27306 View this thread: http://www.excelforum.com/showthread...hreadid=507938 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
downloading from the internet
A few things. Post your code and what line causes the error. Before doing
that in the VB editor select Debug - Compile and see if you have any sysntax errors... -- HTH... Jim Thomlinson "DanMarks" wrote: Hello Excel Help World- I have a list (in excel) of webpages that I want to open and bring into excel. So, I recorded a macro using the Data/Import New Data/New Web Query tool. In VB, I am putting a for loop around this command to successively do all the websites in my list. Since the websites change, I declare a variable (webSite) and set it equal to the cell described by the counter in the for loop. Then, when the recorded macro calls the website, I put in webSite.Value. However, this is giving me a syntax error. Any ideas??? Much thanks for any help you can offer on my problem! Dan Marks -- DanMarks ------------------------------------------------------------------------ DanMarks's Profile: http://www.excelforum.com/member.php...o&userid=31127 View this thread: http://www.excelforum.com/showthread...hreadid=507938 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Downloading files from the the Internet | Excel Worksheet Functions | |||
| Downloading or copying | Excel Discussion (Misc queries) | |||
| downloading an attachment | Excel Worksheet Functions | |||
| Downloading from Bloomberg! | Excel Discussion (Misc queries) | |||
| downloading charts from internet URLs using Excel VBA | Excel Programming | |||
Hybrid Mode
