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
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 m.luxi...@gmail.com wrote:
Workbooks.Open Filename:= _
pt \ rb.Offset(0, -1).Value, _
Origin:=xlWindows, UpdateLinks:=2
With the above