+ Reply to Thread
Results 1 to 7 of 7

Help needed - Macro to Upload multiple files from C drive to a Sharepoint

  1. #1
    Registered User
    Join Date
    08-17-2009
    Location
    Mumbai India
    MS-Off Ver
    Excel 2007
    Posts
    61

    Help needed - Macro to Upload multiple files from C drive to a Sharepoint

    Hello people, Please let me know if there is any macro to Upload multiple files from C drive to a SharePoint. I have the macro which refreshes my excel files however I'm unable to upload them on SharePoint automatically.

    Any help/guidance is much appreciated.

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Help needed - Macro to Upload multiple files from C drive to a Sharepoint

    Hello,

    if you have sufficient permissions to the SharePoint library, you can open it in Windows Explorer. The address bar will show the path to the library on SharePoint. You can now use this like any other folder name in a macro to copy files.

    cheers, teylyn

  3. #3
    Registered User
    Join Date
    08-17-2009
    Location
    Mumbai India
    MS-Off Ver
    Excel 2007
    Posts
    61

    Re: Help needed - Macro to Upload multiple files from C drive to a Sharepoint

    thanks Teylyn, I copied the link from address bar using the windows explorer (the below code) however the files are not getting uploaded

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    08-17-2009
    Location
    Mumbai India
    MS-Off Ver
    Excel 2007
    Posts
    61

    Re: Help needed - Macro to Upload multiple files from C drive to a Sharepoint

    thanks Teylyn, I copied the link from address bar using the windows explorer (the below code) however the files are not getting uploaded

    Please Login or Register  to view this content.

  5. #5
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Help needed - Macro to Upload multiple files from C drive to a Sharepoint

    That is the link from the browser, not from Windows Explorer. Try the method I suggested above.

  6. #6
    Registered User
    Join Date
    08-17-2009
    Location
    Mumbai India
    MS-Off Ver
    Excel 2007
    Posts
    61

    Re: Help needed - Macro to Upload multiple files from C drive to a Sharepoint

    it worked !!

  7. #7
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Help needed - Macro to Upload multiple files from C drive to a Sharepoint

    .If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro to Upload SharePoint project List to Excel then copy to Existing Workbook
    By dawilburn67 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-11-2014, 12:45 PM
  2. Excel macro to sort a column, upload to sharepoint and save as draft on outlook
    By naveenrv in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-20-2013, 02:45 PM
  3. Is it possible to run a macro to upload Access DB to a shared drive?
    By JasonPsychoSO242 in forum Access Tables & Databases
    Replies: 4
    Last Post: 12-28-2012, 02:58 PM
  4. Upload Excel file to Sharepoint using Macro
    By gtg653t in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-10-2008, 10:43 AM
  5. Upload to sharepoint
    By Lp12 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-17-2006, 01:55 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