Pull web data from multiple cell references using VBA

**pkow** · 07-09-2011, 11:16 AM

I'd appreciate any help I can get. Thanks!

What I am trying to accomplish:

I have a list of websites in column B of my "Links" tab. (The # of links may vary)
I want to export data from each website in a loop into cell B1 in my "Results" tab
I want to paste the resulting summary info into my "Summary" tab. Cells A2:AK3 contain the information and i want to paste the results starting in cell A5 on my Summary tab and for each new website, paste 2 rows below where I previously pasted the info.

The code I have now is the begginning of what I think I need to do. I am getting an error in the ".Refresh BackgroundQuery:=False" line of code.

Please Login or Register  to view this content.

**pkow** · 07-09-2011, 02:34 PM

I have been making some progress. I will update with a solution if I indeed have figured this out. Just don't want others spending time on this problem yet.

**pkow** · 07-09-2011, 05:42 PM

So I have fixed up the code so it basically does what my goal was. The 1 issue is that every time Excel stops responding at a different point while it's "Connecting to the web...". I'm not sure if I should be clearing up the memory each loop, or there is some other problem but any help would be appreciated. Thanks.

Please Login or Register  to view this content.

Pull web data from multiple cell references using VBA

LinkBack

Thread Tools

Rate This Thread

Display

Pull web data from multiple cell references using VBA

Re: Pull web data from multiple cell references using VBA

Re: Pull web data from multiple cell references using VBA

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions