Hi Excel PROs
I need some help. I'm trying to paste values from all files in a folder to a master folder but i keep getting errors in the paste process. This is my code:
Sub LoopThrough()Dim MyFile As String
Dim erow
Dim FilePath As String
Dim DestWB As Workbook
Dim SourceWB As Workbook...