Excel到Sharepoint MapNetworkDrive错误 [英] Excel to Sharepoint MapNetworkDrive error

问题描述

使用Excel 2013，我试图使用下面的方法将excel文件上传到sharepoint。我似乎遇到了映射我的网络驱动器的问题，我得到的错误是指定的设备名称无效在 objNet.MapNetworkDriveA：，sFolder 行

Using Excel 2013, I'm trying to upload an excel file to sharepoint using the method below. I seem to be having an issue mapping my network drive, the error I get is "The specified device name is invalid" on the objNet.MapNetworkDrive "A: ", sFolder line.

任何有关此事的帮助都是感谢 - 谢谢提前。

Any help with the matter is appreciated- thanks in advance.

Sub nlsharepoint()

Dim sFolder As String
Dim sFileName As String
Dim locFolder
Dim objNet As Object
Dim FS As Object

sFolder =  "\\company.sharepoint.com\sites\company\Documents\Morning%20Reports\"
sFileName = "New Line Tracker 2.xlsx"
locFolder = "C:\User\Desktop\NewLinesOutput.xlsx"

Set objNet = CreateObject("WScript.Network")
Set FS = CreateObject("Scripting.FileSystemObject")
objNet.MapNetworkDrive "A: ", sFolder

If FS.fileexists(locFolder) Then
FS.copyfile locFolder, sFolder
End If

objNet.RemoveNetworkDrive "A:"
Set objNet = Nothing
Set FS = Nothing
End Sub

推荐答案

我确定这是正确的，但似乎很简单，所以如果不让我知道，我会删除。

I'm sure this is right, but it seems to simple so if not let me know and I'll delete.

我相信你需要替换这一行：

I believe that you need to replace this line:

objNet.MapNetworkDrive "A: ", sFolder

这样：

objNet.MapNetworkDrive "A:", sFolder

指定要映射的驱动器后有一个空格，我不认为应该有。

There's a space after you specify the drive to map, and I don't believe that there should be.

这篇关于Excel到Sharepoint MapNetworkDrive错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！