Hi,
I would like to know how to open multiple excel files from a folder based on the information based in cells down a certain column until the last cell.
I thought it might be something like this but it isn't:
I'm still a noob as it shows so any help would be good.![]()
Sub OpenFiles() Dim eFile As String, totalrows As String totalrows = ActiveSheet.UsedRange.Rows.Count For row = 2 To totalrows eFile = Cells(row, 3).Value Workbooks.Open Filename:=eFile Next row End Sub
Thanks
Bookmarks