Hey people,

I am using Excel 2010 VBA 7.0 scripts to login to Service Now and download the data dump from it in ".csv" format. The version of IE used is 8 or 9 (depending on the system of implementation). The problem is that the default browser used is Microsoft Internet Explorer pops a file download box before saving the data dump in which the folder in which the file has to be downloaded needs to be specified. For this purpose, my automation of fetching the data dump needs human intervention.

Is there any way, we can directly download the data dump file without the file dialog box popup ?