none
Win10 + Excel 2016 fail to connect WebDav with ADODB.connection RRS feed

  • Question

  • Dears,

    We have failed to connect the WebDav(Window Server 2008R2) with ADODB in Win 10 + Excel 2016(32-bit). 

    However, it works properly in Win 7 + Excel 2010 / 2013 (32-bit).

    We have already installed Webfldrs-KB907306-ENU but seems not working.

    Followings are the functions captured in the VBA. Both methods failed.
    ------------------------------------------------------------
    Method 1
    Dim conn As ADODB.Connection
    Set conn = New ADODB.Connection
    conn.Provider = "MSDAIPP.DSO"
    conn.Mode = adModeReadWrite
    Call conn.Open(strPath, gstrWebDavUsr, gstrWebDavPwd)

    ------------------------------------------------------------
    Method 2
    Dim objRecord As New ADODB.Record
    Dim objStream As New ADODB.Stream
    objRecord.Open filePathTo, , adModeReadWrite, adCreateOverwrite, adOpenRecordUnspecified, gstrWebDavUsr, gstrWebDavPwd
    objRecord.Close
    objStream.Type = adTypeBinary
    objStream.Open "URL=" & filePathTo, adModeReadWrite, adOpenRecordUnspecified, gstrWebDavUsr, gstrWebDavPwd
    objStream.LoadFromFile filePathFrom
    objStream.Close

    Set objRecord = Nothing
    Set objStream = Nothing
    ------------------------------------------------------------

    Thank you for your help.
    Friday, October 27, 2017 3:14 AM

All replies

  • Hello,

    This forum (Excel for Developers) is for development issues when using Excel Object Model. I would move this thread into VBA forum as your issue is not related to Excel Object Model. Sorry for any inconvenience.

    Regards,

    Celeste


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, October 30, 2017 2:37 AM
    Moderator
  • I have a same problem. :(

    Somebody can help us? 

    Tuesday, December 5, 2017 1:54 PM
  • Hi,

    Did you solved this problem?

    Thank you

    Monday, August 6, 2018 1:02 PM