Hi-
I have the following code to import a worksheet into my workbook.
Basically, the folder path and file extension are constant, but the actual file name is drawn from cell E2.
I now have a list of file names I want to import. The list always starts in the same cell (A6), but the last row varies based on the list length.
I'm not sure how to change the code above so that the vba loops through all the names listed.
On top of that, I don't want any errors if the file doesn't exist, but rather, the text "Unable to Locate File" should populate in column B of the corresponding row (e.g. if the file listed in A6 doesn't exist, the value of cell B6 should now be "Unable to Locate File")
Appreciate any and all help!
Bookmarks