Trying to run a for each loop on an external workbook with variable number of sheets.
for each wkSht in Workbooks(startFolder).Worksheets
Not sure why it won't work. startFolder is my absolute path to the workbook, as in C:/book.xls
Still new to VBA and I know this is simple. Please help!