Filo
strPath = "Path to Sharepoint Server" '<<< CHANGE
Set oFSO = CreateObject("Scripting.FileSystemObject")
Set oFolder = oFSO.GetFolder(strPath)
Cells(N, 1).Value = oFolder.Path
N = N + 1
For Each oFile In oFolder.Files
Cells(N, 2).Value = oFile.Name
N = N + 1
Next 'oFile
Set oFSO = Nothing
Set oFile = Nothing
Set oFolder = Nothing
End Sub
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming - check out "List Files")
"Filo"
wrote in message
What is the syntax of the path for Sharepoint. We have an https site that
we goto, but is that really the "Path to the Sharepoint Server" listed in
Jim's code?
Thanks.
my strPath is "https://client.us.com/clientname/default.aspx"
also tried "https://client.us.com/clientname/"
and "https://client.us.com/"
None worked.
--
JNW
Thanks,
net_prof