<?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: load files whit excel vba in Dropbox API Support &amp; Feedback</title>
    <link>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/load-files-whit-excel-vba/m-p/454556#M23507</link>
    <description>&lt;P&gt;I'm not sure if it's possible to create a VBA script to upload to Dropbox directly, however, you can look into the &lt;A href="https://www.dropbox.com/developers/documentation/http/overview" target="_blank"&gt;Dropbox API documentation&lt;/A&gt; for more information to see&amp;nbsp;if there is any possibility of doing so using the info there.&lt;/P&gt;</description>
    <pubDate>Fri, 18 Sep 2020 20:33:32 GMT</pubDate>
    <dc:creator>Jay</dc:creator>
    <dc:date>2020-09-18T20:33:32Z</dc:date>
    <item>
      <title>load files whit excel vba</title>
      <link>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/load-files-whit-excel-vba/m-p/453311#M23504</link>
      <description>&lt;P&gt;Hi.&lt;/P&gt;
&lt;P&gt;I would like to receive an example on how to upload a file (ie *.xlsm) to dropbox from excel using vba.&lt;/P&gt;
&lt;P&gt;Thanks a lot.&lt;/P&gt;</description>
      <pubDate>Wed, 23 Sep 2020 17:30:00 GMT</pubDate>
      <guid>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/load-files-whit-excel-vba/m-p/453311#M23504</guid>
      <dc:creator>smarta1</dc:creator>
      <dc:date>2020-09-23T17:30:00Z</dc:date>
    </item>
    <item>
      <title>Re: load files whit excel vba</title>
      <link>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/load-files-whit-excel-vba/m-p/453352#M23505</link>
      <description>&lt;P&gt;Hi &lt;a href="https://www.dropboxforum.com/t5/user/viewprofilepage/user-id/1350877"&gt;@smarta1&lt;/a&gt;, thanks for posting on the Community!&lt;/P&gt;

&lt;P&gt;&amp;nbsp;&lt;/P&gt;

&lt;P&gt;Are you trying to upload files to Dropbox directly using the Excel app, or via Office Online?&lt;/P&gt;

&lt;P&gt;&amp;nbsp;&lt;/P&gt;

&lt;P&gt;Keep me posted!&lt;/P&gt;</description>
      <pubDate>Tue, 15 Sep 2020 00:38:43 GMT</pubDate>
      <guid>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/load-files-whit-excel-vba/m-p/453352#M23505</guid>
      <dc:creator>Jay</dc:creator>
      <dc:date>2020-09-15T00:38:43Z</dc:date>
    </item>
    <item>
      <title>Re: load files whit excel vba</title>
      <link>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/load-files-whit-excel-vba/m-p/454511#M23506</link>
      <description>&lt;P&gt;Hi Jay.&lt;/P&gt;&lt;P&gt;Thanks for your answer.&lt;/P&gt;&lt;P&gt;I am using MS Excel (Microsoft Office) on a Desktop with Windows 8.1 (No Office Online).&lt;/P&gt;&lt;P&gt;I would like to have a VBA routine to insert in my excel file (*.xlsm).&lt;/P&gt;&lt;P&gt;Best regards.&lt;/P&gt;</description>
      <pubDate>Fri, 18 Sep 2020 17:42:28 GMT</pubDate>
      <guid>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/load-files-whit-excel-vba/m-p/454511#M23506</guid>
      <dc:creator>smarta1</dc:creator>
      <dc:date>2020-09-18T17:42:28Z</dc:date>
    </item>
    <item>
      <title>Re: load files whit excel vba</title>
      <link>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/load-files-whit-excel-vba/m-p/454556#M23507</link>
      <description>&lt;P&gt;I'm not sure if it's possible to create a VBA script to upload to Dropbox directly, however, you can look into the &lt;A href="https://www.dropbox.com/developers/documentation/http/overview" target="_blank"&gt;Dropbox API documentation&lt;/A&gt; for more information to see&amp;nbsp;if there is any possibility of doing so using the info there.&lt;/P&gt;</description>
      <pubDate>Fri, 18 Sep 2020 20:33:32 GMT</pubDate>
      <guid>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/load-files-whit-excel-vba/m-p/454556#M23507</guid>
      <dc:creator>Jay</dc:creator>
      <dc:date>2020-09-18T20:33:32Z</dc:date>
    </item>
    <item>
      <title>Re: load files whit excel vba</title>
      <link>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/load-files-whit-excel-vba/m-p/454570#M23508</link>
      <description>&lt;P&gt;Hi Jay.&lt;/P&gt;&lt;P&gt;I asked because I found the following but I do not know if is complete:&lt;/P&gt;&lt;P&gt;Public Sub DB_PutFile(FileName As String)&lt;/P&gt;&lt;P&gt;Dim req As MSXML2.ServerXMLHTTP60&lt;/P&gt;&lt;P&gt;Dim strFile As String&lt;/P&gt;&lt;P&gt;Dim Pos1 As Integer&lt;/P&gt;&lt;P&gt;Dim Pos2 As Integer&lt;/P&gt;&lt;P&gt;Dim arg As String&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; Set req = New MSXML2.ServerXMLHTTP60&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; strFile= ReadBinary(FileName)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; arg = "{""path"":""/" &amp;amp; FileName &amp;amp; """,""mode"":{"".tag"":""overwrite""},""autorename"":false,""mute"":true}"&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; req.Open "POST", "&lt;A href="https://content.dropboxapi.com/2/files/upload" target="_blank"&gt;https://content.dropboxapi.com/2/files/upload&lt;/A&gt;", False&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; req.setRequestHeader "Authorization", "Bearer xxxxxxxxxxxxxxxx"&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; req.setRequestHeader "Content-Type", "application/octet-stream"&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; req.setRequestHeader "Content-length", Len(Result)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; req.setRequestHeader "Dropbox-API-Arg", arg&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; req.setRequestHeader "User-Agent", "api-explorer-client"&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; req.send strFile&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp; &amp;nbsp;If req.Status = 200 Then&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Debug.Print req.responseText&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; Else&lt;/P&gt;&lt;P&gt;'MsgBox req.Status &amp;amp; ": " &amp;amp; req.statusText&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Debug.Print req.responseText&lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; End If&lt;/P&gt;&lt;P&gt;End Sub&lt;/P&gt;&lt;P&gt;Can you help me?&lt;/P&gt;&lt;P&gt;Best regards.&lt;/P&gt;</description>
      <pubDate>Fri, 18 Sep 2020 21:49:18 GMT</pubDate>
      <guid>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/load-files-whit-excel-vba/m-p/454570#M23508</guid>
      <dc:creator>smarta1</dc:creator>
      <dc:date>2020-09-18T21:49:18Z</dc:date>
    </item>
    <item>
      <title>Re: load files whit excel vba</title>
      <link>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/load-files-whit-excel-vba/m-p/455691#M23509</link>
      <description>&lt;P&gt;It does look like some API calls are made there. I can move this thread to the API forum, however, bear in mind that we might not be able to assist with the VBA script as it isn't related to Dropbox itself.&lt;/P&gt;</description>
      <pubDate>Wed, 23 Sep 2020 15:19:56 GMT</pubDate>
      <guid>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/load-files-whit-excel-vba/m-p/455691#M23509</guid>
      <dc:creator>Jay</dc:creator>
      <dc:date>2020-09-23T15:19:56Z</dc:date>
    </item>
    <item>
      <title>Re: load files whit excel vba</title>
      <link>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/load-files-whit-excel-vba/m-p/455707#M23510</link>
      <description>&lt;P&gt;&lt;a href="https://www.dropboxforum.com/t5/user/viewprofilepage/user-id/1350877"&gt;@smarta1&lt;/a&gt;&amp;nbsp;&lt;A href="https://www.dropbox.com/developers" target="_self"&gt;The&amp;nbsp;Dropbox API&lt;/A&gt; does offer the ability to programmatically upload files, such as by using &lt;A href="https://www.dropbox.com/developers/documentation/http/documentation#files-upload" target="_self"&gt;/2/files/upload&lt;/A&gt; as referenced in the code you shared. Please refer to the documentation linked there for information on using that.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Give that a try and if something on the API isn't working expected, please share the error/output.&lt;/P&gt;</description>
      <pubDate>Wed, 23 Sep 2020 16:01:57 GMT</pubDate>
      <guid>https://www.dropboxforum.com/t5/Dropbox-API-Support-Feedback/load-files-whit-excel-vba/m-p/455707#M23510</guid>
      <dc:creator>Greg-DB</dc:creator>
      <dc:date>2020-09-23T16:01:57Z</dc:date>
    </item>
  </channel>
</rss>

