+ Reply to Thread
Results 1 to 2 of 2

VBA save to sharepoint library failed

  1. #1
    Forum Contributor
    Join Date
    07-16-2013
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2013
    Posts
    176

    VBA save to sharepoint library failed

    I have this code that's working for 5+ years, it stopped working today and I cant figure out why. I found a work around, if i mapped "http://sharepoint/sites/IT/test/" and drive letter x, and ask it to save to x, it works fine. The solution is acceptable, but I want to know why this is happening.

    Thanks in advance!

    Please Login or Register  to view this content.

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,883

    Re: VBA save to sharepoint library failed

    Nothing to do with VBA. Likely cause, would be security/protocol change on the server housing SharePoint.

    May be IT/Network Admin implemented TLS and it's been updated to 1.2 (current standard) from 1.0/1.

    Or some other change took place recently.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

+ 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. FileLen Syntax Not working for Sharepoint Library url
    By Seth_ in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-22-2019, 10:48 AM
  2. Excel Sharepoint New File Library
    By Teddi in forum Excel General
    Replies: 0
    Last Post: 01-30-2019, 07:51 AM
  3. [SOLVED] VBA - Tag of a two-dimensional variable in a SharePoint library
    By Air1_16 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-02-2017, 12:13 PM
  4. VBA to loop through all files in a Sharepoint library/folder
    By red1234 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-17-2016, 07:09 AM
  5. Replies: 0
    Last Post: 10-05-2015, 10:45 PM
  6. Sharepoint Excel Document Library Setup
    By Blackbird_71 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-05-2015, 01:14 PM
  7. Macro to save to sharepoint library
    By chris.tinta in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-07-2012, 10:08 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