VBA Loop to open other Workbooks based on cell information

[Sin]

Good Afternoon,

I have been searching through the forums, not found what I am looking for. If somebody knows of if this has been answered elsewhere, happy to go to that thread for the info.
My conundrum!
I have a worksheet that has a list of workbook names and locations. I need a piece of VBA code that will open the workbook based on the name in cell, I will get it to do something whilst it is open, then close the workbook, and cycle onto the next cell down to do the same again, until it finds a blank cell and stops.

Thanks a million for the help

Ash

 

[Fluff]

Does the column contain the full filepath & workbook name?

 

[Sin]

Does the column contain the full filepath & workbook name?

It does indeed

 

[Fluff]

In that case, how about

Sub SinTest()
   Dim Wbk As Workbook
   Dim Cl As Range
   For Each Cl In Range("A2", Range("A" & Rows.Count).End(xlUp))
      Set Wbk = Workbooks.Open(Cl.Value)
      ' do something here
      Wbk.Close [COLOR=#ff0000]False[/COLOR]
   Next Cl
End Sub

Change the False to True if you want to save the other workbook before closing it.

 

[Sin]

Fluff
Thanks for the help, doing exactly what I need.

 

[Fluff]

Glad to help & thanks for the feedback