Neither response is useful. I am facing the same problem literally in similar circumstances. Trying to run an activity in the course work to replicate results displayed in the video. After running the code, the library is actually assigned, but not a single worksheet from the workbook was distributed into it. The message error came from the proc contents part of the code, because the worksheet it is trying to assess actually does not exist in the concerned library. The question is: how can the library be properly assigned and the worksheets not distributed, when the Excel spreadsheet actually exists and the log did not return a "File not found" or "File does not exist" error message? That's the crux of the question that needs to be addressed. ... View more