I have a code to extract data from a closed worksheet, but I keep getting an error (See the attached pictureerror.PNG)
So what I'm trying to do is open a file whose name keeps changing. I have the path to the file (including the file name) in an Instructions sheet in cell C29.
The name of the sheet I'm trying to open also changes, it's called "C18 Summary", so the value 18 is defined in the instructions sheet in Cell C23. And form this sheet the range I'm trying to copy is A61:R66.
I think the error is, and correct me if I'm wrong, but the file I trying to open in Cell 29 is not actually being opened?
How did I fix this??
Please Login or Register to view this content.
Bookmarks