View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default dynamic web queries with vba

Randy,
Record a macro when you create 1 web query.
Modify the code to change the URL and Destination within a loop

NickHK

"rbarning" wrote in
message ...

Hello,

I am trying to create multiple web queries where I pull in data in from
a url where I have the urls (around 10 of them) in an excel workbook.

Any help would be hugely appreciated.

thanks

Randy


--
rbarning
------------------------------------------------------------------------
rbarning's Profile:

http://www.excelforum.com/member.php...o&userid=37787
View this thread: http://www.excelforum.com/showthread...hreadid=573544