Hi,

I have a series of CSV files in my website: www.example.com/files
This directory is password protected and it is used to store the files from which Excel is returning fresh data to an application.

Is it possible to build a VBA query with the user/password in it to automatically log in to this directory before the web queries are executed?

I tried the instructions in a similar post http://www.excelforum.com/excel-prog...-password.html, but they don't work in my case since the user id/password are requested by a pop-up window.

Thanks in advance for any help