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>>>
Bookmarks