I haven't tested this, but I do not think it should be 2. Should be 0
Regards,
Sam
On Mon, Oct 10, 2011 at 9:07 PM, Mahen wrote:
> Workbooks.Open Filename:= _
>pt & "\" & rb.Offset(0, -1).Value, _
>Origin:=xlWindows, UpdateLinks:=2
>
> With the above in a loop,
Workbooks.Open Filename:= _
pt & "\" & rb.Offset(0, -1).Value, _
Origin:=xlWindows, UpdateLinks:=2
With the above in a loop, a series of workbooks are open from path pt
with workbook names from the variable rb.offset(0,-1).value for
reading data from them and these
