title: Adding credentials to Excel web query file
body: <p>I have a file_name.iqy file which I am trying to open automatically within Excel 2016. </p>
  
  <p>The contents of the file are this: </p>
  
  <pre><code>WEB
  1
  https://link goes here
  Selection=3
  Formatting=Rich Text
  DisableRedirections=False
  </code></pre>
  
  <p>I want to add my credentials into this file so I can stop being prompted for them within the script that I am running (I am trying to automate logging into this site and grabbing the data which is downloaded as an .iqy file). Can anyone provide any assistance? Lastly, I have no reason to believe that link in the file is static for each download.</p>
  
  <p>Ive tried this method <a href="http://username:password@example.com/" rel="nofollow noreferrer">http://username:password@example.com/</a> in the url. But it didnt work. Ive also tried using SendKeys from within Excel and the result in VBA is hanging at the part for credential entering.</p>