I changed:
toPHP Code:
.Cells(LR, "z").Resize(UBound(a)) = ws.Name
and it works fine.PHP Code:
.Cells(LR, "z").Resize(UBound(a)) = FileName.Name
But still only first 2 raws of the workbooks are pasted.
I changed:
toPHP Code:
.Cells(LR, "z").Resize(UBound(a)) = ws.Name
and it works fine.PHP Code:
.Cells(LR, "z").Resize(UBound(a)) = FileName.Name
But still only first 2 raws of the workbooks are pasted.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks