Hello,
I am VERY new to VBA and I am getting a strange error when I run my macro. The code is below and the goal is to combine "Sheet1" of several workbooks into a new workbook (basically making a master for all of my spreadsheets). When I run it, I get the error pictured below, however, the file it cannot find is definitely in the folder. Can anyone help me solve this error? THANK YOU!
Capture.PNG
CODE:
Please Login or Register to view this content.
Bookmarks