Results 1 to 2 of 2

VBA Dropbox links

Threaded View

  1. #1
    Registered User
    Join Date
    02-18-2015
    Location
    Sweden
    MS-Off Ver
    2010
    Posts
    7

    VBA Dropbox links

    Hello!

    I could use some help with this, atm it lets me browse for a file on my computer and puts the link to file in a textbox.

    The problem is when I select a file in my dropbox. I want the output link in the textbox to be the dropbox online link instead of the local file link, is it possible ?

    This is the code I got for my local files (I only want it to output dropbox links instead)


    Private Sub CommandButton21_Click()
    Dim Filter As String, Title As String
    Dim FilterIndex As Integer
    Dim Filename As Variant
    Filter = "View All Files (*.*),*.*,"
    
    
    FilterIndex = 1
    Title = "Select a File to Open"
    ChDrive ("C")
    ChDir ("C:\")
    With Application
        Filename = .GetOpenFilename(Filter, FilterIndex, Title)
        ChDrive (Left(.DefaultFilePath, 1))
        ChDir (.DefaultFilePath)
        TextBox21.Text = Filename
    End With
    End Sub

    Have a good one!

    /Johan
    Last edited by alansidman; 02-27-2015 at 10:00 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. need to add another value in the dropbox
    By rolosa in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-30-2014, 12:09 PM
  2. need to add another value in the dropbox
    By rolosa in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-30-2014, 10:49 AM
  3. Excel VBA Code to upload a file to Dropbox using the Dropbox API
    By gb# in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-02-2014, 03:41 PM
  4. Moved .xlsm file to dropbox now get error msg "Links can not be updated"
    By capson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-20-2014, 10:31 AM
  5. [SOLVED] How to get sum value of dropbox values
    By isixes27ce in forum Excel General
    Replies: 3
    Last Post: 11-11-2012, 10:51 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1