Home > Forum Home > Excel Portfolio Optimization Template > How can data be added in an Excel file from a remote Excel file (hosted on the web)? > Reading remote Excel files | Share |
Forum Topic | Login |
Reading Remote Excel Files | Rate this: (4/5 from 3 votes) |
You can read remote files in Excel VBA using the XMLHTTP object. You will want to ready the content of the file and then save it to file locally to use the content via copying or extract data from the object stream. | ||
Excel Business Forums Administrator | ||
Posted by Excel Helper on |
View Full Post |
Find relevant Excel templates and add-ins for Reading remote Excel files in the Excel Business Solutions Directory |