Connectivity between local machine and external excel file using VBA RRS feed

  • Question

  • Hello all,

    I am trying to pull data from an external excel document from a website to an excel workbook on my local machine. The website requires you to click the excel document, which will then open the workbook for you to view. Is there a way to establish some kind of connection that will allow me access to pull this data? In my previous experience, I have used JDBC templates for java when establishing a connection to a database, and excel is pretty similar to a database. For excel, I am using VBA, which isn't a difficult language. I just can not seem to figure out how to extract external data to write to my local workbook. Thanks for any help!

    Tuesday, December 4, 2018 7:14 PM

All replies

  • Without knowing the website it is hard to provide specific advice.  It may be possible to use command line programs like CURL or WGET to download file.   You'll have to extract workbook url from website.  Provide the website to get more specific recommendations.
    Wednesday, December 5, 2018 12:51 PM