VBA: Remotely refresh queries in another workbook
<p>I am working with two workbooks. I am inserting data in one and the other is taking part of this data via Excel query, thus I have to open the second one every time I want to refresh the information, as I am sharing it with other users.</p>

<p>In few words, I would like to remotely refresh the second workbook when I am updating the main one so I do not have to continuously open, refresh and close.</p>

<p>Let's assume that both workbooks are in the same folder in Dropbox, for example.</p>

<p>Thanks a lot!</p>