title: VBA to omit save as popup from internet explorer while downloading xls file
body: <p>I have searched many websites to get the answer but could not succeeded.</p>
  
  <p>I want to download xls file from my company website, and through VBA i was able to sign in and then change few parameter and lastly I clicked on export button. after clicking on export button xls file will be downloaded but then I got a pop up from internet explorer about save/save as/open.</p>
  
  <p>So finally I am stuck here, I used send keys to download this but is there any other option which will save xls file in my defined path and pre defined xls name.</p>
  
  <p>there is another problem that after clicking on export button xls file name can be any thing.</p>
  
  <p>thanks so much in advance for your help.</p>