I would like a some help on opening up multiple excel WB that have individual network paths, save and close them.
I would like to manage the paths in cells within a worksheet. There would be two columns: Workbook Name and Workbook Path and multiple rows.
|1||Workbook Name||Workbook Path|
I have notice in searching the forum the below code that would seem to be very useful. However I do not know I would implement this in my Worksheet.
can anyone help advise please...
Dim i As Long
For i = 7 To Cells(.Rows.Count, 1).End(xlUp).Row
If LCase(Mid(.Cells(i, 1).Value, InStrRev(.Cells(i, 1).Value, ".") + 1, 3)) = "xls" Then Workbooks.Open .Cells(i, 1).Value