title: Calling a javascript file (.js) via Excel VBA?
body: <p>How to call a javascript file (.js) via Excel VBA?</p>
  
  <hr>
  
  <p>So as i am opposed to the same kind of problem i'll try to submit you guys my case.</p>
  
  <p>I am trying to automate datas extraction from valeo's catalogue using excel vba macro.</p>
  
  <p>I have a list of références attached to valeo's automotive products (huge list, as more than 3000 thousands items). And i would like to import directly informations from the catalogue wich seems to run under javascript.</p>
  
  <p>The datas i need is the list of every vehicules attached to a reference.</p>
  
  <p>Here is the url: <a href="http://outcat-cs.tecdoc.net/ows/en/7FA2A0C501BC34CA4BECB04095663CF1.ows_cs2.srv?view=VIndexFramesetJsp" rel="nofollow noreferrer">http://outcat-cs.tecdoc.net/ows/en/7FA2A0C501BC34CA4BECB04095663CF1.ows_cs2.srv?view=VIndexFramesetJsp</a></p>
  
  <p>I'd like to access to the "Direct Article Search" tab, in order to copy a reference directly from an excel tab's cell and then simulate a clic on the reference in order to display the "linked vehicules section" and then to copy them in a new excel sheet.</p>
  
  <p>I already succeede in doing this with html pure programmed webpage (oscaro.com) using the following code :</p>
  
  <pre><code>Set maPageHtml = IE.document
  Set Helem = maPageHtml.getElementsByTagName("input")
  
  For i = 0 To Helem.Length - 1 
      If Helem(i).getAttribute("name") = "toFind" Then Helem(i).Value = "819971" '819971 is the valeo reference searched
      If Helem(i).getAttribute("name") = "submit" Then Set Monbouton = Helem(i)
  Next
  
  Monbouton.Click 'this does the click on my button Monbouton
  </code></pre>
  
  <p>But this technique can't be used with valeo website since I am not able (or at least I don't know yet how to do it) to select/click a button when the page is made on javascript, since it doesn't have a name, value or id for the button.</p>
  
  <p>Also it seems that the url in the address field is the same before clicking on the "Direct Article Search" button and after having clicked....</p>
  
  <p>Hope i am clear enought in spite of my english...</p>
  
  <p>Greetings</p>