title: Web Scraping through Excel VBA
body: <p>I need to fetch company addresses(cim) from site <strong><a href="http://www.ceginfo.hu/" rel="nofollow">http://www.ceginfo.hu/</a></strong></p>
  
  <p>Example Company Name: AB-KONTÍR Szolgáltató Bt.</p>
  
  <p>I know how to do it using <strong>WinHttp.WinHttpRequest</strong> object and <strong>FireBug</strong>. </p>
  
  <blockquote>
    <p>But I am not able to decide to which URL I should send this request.</p>
  </blockquote>
  
  <p>When I analyse the request/responses using FireBug, I get the following URL:
  <a href="http://www.ceginfo.hu/company/search/4221638" rel="nofollow">http://www.ceginfo.hu/company/search/4221638</a></p>
  
  <p>4221638 is CompanyID here I think. But in my case I will have company name only and that's what my problem is.</p>
  
  <p>So can anybody please tell me where can I get URL using firebug or any other tool using which I can track the URL <strong>with Company Name as parameter</strong> which I can use in my VBA code.</p>
  
  <p>Thanks in advance!</p>