Hi,

I have an Excel File with tabular data. The file is located in our company's file server with path similar to the below

http://files.company_name.com/content/Private/Book1.xls

I am trying to create an excel file on my desktop , which when clicked will import the data into the file on my desktop. The above file location needs username and password.


How to achieve this?
WebQuery is not useful , since I have to use SQL statements to manipulate the recordset before importing the data.



Thanks in Advance for help
Shij>>>