Trying to consolidate files off Sharepoint (URGENT REQUEST)

avila11

New member
Joined
Jan 9, 2015
Messages
1
Reaction score
0
Points
0
I am working to consolidate a certain sheet out of all the workbooks saved in a particular folder on Sharepoint. This is the current set up, but I keep getting error 76 (path not found). Please help, urgent!

Sub simpleXlsMerger()
Dim bookList As Workbook
Dim mergeObj As Object, dirObj As Object, filesObj As Object, everyObj As Object
Application.ScreenUpdating = False
Set mergeObj = CreateObject("Scripting.FileSystemObject")

Set dirObj = mergeObj.Getfolder("//sharepoint/sites/portmgmt/Capability and Portfolio Planning/John's Merger Test/PES")
Set filesObj = dirObj.Files
For Each everyObj In filesObj
Set bookList = Workbooks.Open(everyObj)
bookList.Worksheets("Forecast").Activate

Range("A4:IV" & Range("A65536").End(xlUp).Row).Copy
ThisWorkbook.Worksheets(1).Activate

Range("A65536").End(xlUp).Offset(1, 0).PasteSpecial
Application.CutCopyMode = False
bookList.Close
Next
End Sub
 
Back
Top