Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Excel 2010 WebDav Connection to SharePoint Errors

20 Apr 2012   #1

Win 7 Enterprise 64 Bit
Excel 2010 WebDav Connection to SharePoint Errors

I am in the process of assisting some users in switching from Win XP/Office 2003 -> Win 7/Office 2010 and have hit a roadblock. I have a user that has an excel macro that opens an ADO connection to a SharePoint and grabs a record of the excel files on the SharePoint. The macro works perfectly on XP/2003 and XP/2010 but fails on 7/2010.
They are using this connection line:
davDir.Open "", "URL=http://SharePoint/Directory/URL", _ 
   adModeRead, adFailIfNotExists, adDelayFetchStream
Set davFiles = davDir.GetChildren()
Once they have the record they iterate through each Excel file on the SharePoint to open and parse them.

On Win7/2010 I get these errors when it gets to the davDir.Open line:

When they error trap it throws this error:

Object or data matching the name, range, or selection criteria was not found within the scope of this operation.
Without error trapping it throws this error:

Run-time error '-2147217895 (80040e19):Automation error
I can connect to the SharePoint fine via IE or File/Open in Excel 2010. I have tried every variation of the URL I can and I just keep getting the same error.

Does anyone have any ideas? The fact it works on XP/2010 screams Win 7 issue to me, but beyond that I am lost. I have spent the last 2 days scouring Google and I am starting to lose my mind.


My System SpecsSystem Spec
31 May 2012   #2

Windows 7 Enterprise

I've had just this problem and have narrowed it down to making the connection. The following code produces the same error on SP 2007 from Win 7:

Dim Conn As New ADODB.Connection
sURL = "http://sharepointtest2/personal/kraviss/Test docs/ACT Contracts Data" RepositoryRepository"
Conn.Open "URL=" & sURL

I've found WebDav to be most unreliable when uploading files to SP doc libraries and a little less unreliable when reading properties. I use the Frontpage Server extensions to do most uploading. FilesystemObject calls work most of the time to get file and folder properties - the following code fragment will get folder contents. sFolder is the UNC path for the SP doc library

Dim objFSO as New Scripting.filesystemobject
Dim objFolder as Scripting.Folder
Dim colFiles as Scripting.Files
Dim colFolders as Scripting.Folders

sFolder = "\\sharepointtest2\personal\kraviss\Test docs\ACT Contracts Data"
set objFolder = objFSO.GetFolder(sFolder)
set colFiles = objFolder.Files
set colFolders = objFolder.Subfolders

This will need a reference to Microsoft Scripting Runtime scrrun.dll in C:\Windows\SysWOW64
My System SpecsSystem Spec

 Excel 2010 WebDav Connection to SharePoint Errors

Thread Tools

Similar help and support threads
Thread Forum
Network location for hosted SharePoint / WebDAV issue
FNG here. I'm using Win 7, full RC, 32 bit. This problem happens on any machine and happened in Vista 32 bit as well. I host our SharePoint server externally at Apptix and I am unable to map a network location to show up in Explorer. I'm not technical enough to know if this is a WebDAV issue...
Network & Sharing
Outlook 2010 - Calendar Publishing to WebDAV
Hi everyone Have recently installed Outlook 2010 and have previously used calendar sharing via WebDAV server... My Outlook 2010, unfortunately.. seems to have the publishing options greyed out and after an extremely long time googling... I am still no closer to working out why... I have...
Microsoft Office
Formatting Excel 2010, Excel 2003
Hello, I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns. It's a cinch when...
Microsoft Office
Sharepoint Server 2010 as a VM Anyone
Hi all I've been interested in testing out Sharepoint server 2010 as a VM. It appears to make a good testing platform for Office / Web services etc etc. Anyone tested this / tried it -- performance wise with say 5 or 6 workstations attached. I'm thinking If it's possible of running one...
Announcing Service Pack 1 for Office 2010 & SharePoint 2010
From TechNet flash newsletter: Scheduled for release at the end of June, SP1...more details.

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 17:26.
Twitter Facebook Google+