<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Download file with VBA in Dropbox API Support &amp; Feedback</title>
    <link>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/Download-file-with-VBA/m-p/485231#M24381</link>
    <description>&lt;P&gt;&lt;A href="https://www.dropbox.com/developers/documentation/http/documentation#files-download" target="_self"&gt;The&amp;nbsp;/2/files/download endpoint&lt;/A&gt; is &lt;A href="https://www.dropbox.com/developers/documentation/http/documentation#formats" target="_self"&gt;a "content-download" style endpoint&lt;/A&gt;, meaning that when the call is successful, the requested file data is returned in the response body.&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;It sounds like that is what you're seeing. That is, the text you're reading out is the raw file data. What you do with that data is up to you.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;For instance, in this case, it sounds like you want to save that file data to the local file system.&amp;nbsp;Dropbox can't offer support for interacting with the local filesystem in VBA, as that's not made by Dropbox, but it looks like you may want to use&amp;nbsp;&lt;A href="https://docs.microsoft.com/en-us/office/vba/Language/Reference/User-Interface-Help/filesystemobject-object" target="_self"&gt;FileSystemObject&lt;/A&gt;.&lt;/P&gt;</description>
    <pubDate>Thu, 07 Jan 2021 16:13:59 GMT</pubDate>
    <dc:creator>Greg-DB</dc:creator>
    <dc:date>2021-01-07T16:13:59Z</dc:date>
    <item>
      <title>Download file with VBA</title>
      <link>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/Download-file-with-VBA/m-p/485057#M24378</link>
      <description>&lt;P&gt;Hi&lt;BR /&gt;&lt;BR /&gt;I'm a DB beginner and have to use VBA from Excel&lt;BR /&gt;I'm using, in between others:&lt;/P&gt;
&lt;PRE&gt;Set xmlhttp = CreateObject("WinHttp.WinHttpRequest.5.1")&lt;/PRE&gt;
&lt;PRE&gt;myURL = "https://content.dropboxapi.com/2/files/download"&lt;/PRE&gt;
&lt;PRE&gt;xmlhttp.SetRequestHeader "Dropbox-API-Arg", argumentString&lt;BR /&gt;xmlhttp.send ""&lt;/PRE&gt;
&lt;P&gt;and it all seems to go well and with&lt;/P&gt;
&lt;PRE&gt;xmlhttp.ResponseText&lt;/PRE&gt;
&lt;P&gt;I get a bunch of unreadable text which I believe is the file content&lt;BR /&gt;But I don't get the file&lt;BR /&gt;&lt;BR /&gt;what should be the last statament to actually download it to my PC?&lt;BR /&gt;&lt;BR /&gt;thank you&lt;BR /&gt;&lt;BR /&gt;Riccardo&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;</description>
      <pubDate>Thu, 07 Jan 2021 08:16:24 GMT</pubDate>
      <guid>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/Download-file-with-VBA/m-p/485057#M24378</guid>
      <dc:creator>Riccardo Chojwa</dc:creator>
      <dc:date>2021-01-07T08:16:24Z</dc:date>
    </item>
    <item>
      <title>Re: Download file with VBA</title>
      <link>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/Download-file-with-VBA/m-p/485231#M24381</link>
      <description>&lt;P&gt;&lt;A href="https://www.dropbox.com/developers/documentation/http/documentation#files-download" target="_self"&gt;The&amp;nbsp;/2/files/download endpoint&lt;/A&gt; is &lt;A href="https://www.dropbox.com/developers/documentation/http/documentation#formats" target="_self"&gt;a "content-download" style endpoint&lt;/A&gt;, meaning that when the call is successful, the requested file data is returned in the response body.&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;It sounds like that is what you're seeing. That is, the text you're reading out is the raw file data. What you do with that data is up to you.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;For instance, in this case, it sounds like you want to save that file data to the local file system.&amp;nbsp;Dropbox can't offer support for interacting with the local filesystem in VBA, as that's not made by Dropbox, but it looks like you may want to use&amp;nbsp;&lt;A href="https://docs.microsoft.com/en-us/office/vba/Language/Reference/User-Interface-Help/filesystemobject-object" target="_self"&gt;FileSystemObject&lt;/A&gt;.&lt;/P&gt;</description>
      <pubDate>Thu, 07 Jan 2021 16:13:59 GMT</pubDate>
      <guid>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/Download-file-with-VBA/m-p/485231#M24381</guid>
      <dc:creator>Greg-DB</dc:creator>
      <dc:date>2021-01-07T16:13:59Z</dc:date>
    </item>
    <item>
      <title>Re: Download file with VBA</title>
      <link>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/Download-file-with-VBA/m-p/485263#M24383</link>
      <description>&lt;P&gt;Hi Greg&lt;BR /&gt;&lt;BR /&gt;thanks for your prompt and clear feedback&lt;BR /&gt;I get what you mean and I'm going to dig into it&lt;BR /&gt;&lt;BR /&gt;I have another question but I'll start a new thread&lt;BR /&gt;Riccardo&lt;BR /&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;</description>
      <pubDate>Thu, 07 Jan 2021 17:32:05 GMT</pubDate>
      <guid>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/Download-file-with-VBA/m-p/485263#M24383</guid>
      <dc:creator>Riccardo Chojwa</dc:creator>
      <dc:date>2021-01-07T17:32:05Z</dc:date>
    </item>
  </channel>
</rss>

