Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening with Excel All Word documents of a Sharepoint site
From all Word documents on a Sharepoint site I want to copy
information to an Excel workbook. I can open just 1 document en copy the information to Excel, but how do I open all the files? -- The following code Works fine for 1 document: Dim appWord As Word.Application, docWord As Word.Document Dim strPath As String Set appWord = GetObject(, "Word.Application") code strPath = "http://server/folder/folder/test.docm" Set docWord = appWord.Documents.Open(strPath) --- the following code gives an error (Path not found) Dim objFSO As Object , objFolder As Object, strPath as String strPath = "http://server/folder/folder" (with or without an extra /) Set objFSO = CreateObject("Scripting.FileSystemObject") Set objFolder= objFSO.Folder(strPath) In the View / Explorer the path is the same as on the Sharepointsite, as given voor strPath What do I wrong??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Synchronising Excel Documents Across SharePoint | Excel Discussion (Misc queries) | |||
Accessing Excel Documents on a SharePoint Site | Excel Programming | |||
VBA Code to open an Excel file on a sharepoint site | Excel Programming | |||
Having problems saving pdf's from excel to a sharepoint site. | Excel Programming | |||
Shared Excel Documents and SharePoint | Excel Discussion (Misc queries) |