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

Reading remote Excel files

Excel Help for Reading Remote Excel Files in Excel Portfolio Optimization Template


Forum TopicLogin

Reading Remote Excel Files

Rate this:
(4/5 from 3 votes)
Confused 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 on
 
View Full Post

Find relevant Excel templates and add-ins for Reading remote Excel files in the