I have the names of Excel files I want to open in an array. Can I use those String objects as the workbook index?
nameText = "Revenue.xlsx" Set myValues = Workbooks(nameText).Worksheets(1).Columns("J")
I believe I’m running into a problem with
Workbooks(nameText) — what can I do to make that work?