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)? Share

How can data be added in an Excel file from a remote Excel file (hosted on the web)?

Excel Help for How Can Data Be Added In An Excel File From A Remote Excel File (hosted On The Web)? in Excel Portfolio Optimization Template


Forum TopicPost Reply Login

How Can Data Be Added In An Excel File From A Remote Excel File (hosted On The Web)?

Rate this:
(3/5 from 1 vote)
Confused Do you have any idea about procedure of data to be added in Excel file from remote excel file.
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most Recent | Chronological | Highest Rated
Confused
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 on
 Displaying page 1 of 1 

Find relevant Excel templates and add-ins for How can data be added in an Excel file from a remote Excel file (hosted on the web)? in the