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

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

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