I have a macro that I haven't used for a long time, and I would like to get it up and going again. It comes to a grinding halt where my code reads,
Code:
Workbooks.Open FileName:=fileloc
I receive a message, Run-time error '1004': and it tells me my file could not be found. Yes, Ive changed my file location, and its now up in the sky (onedrive) . Thats where I want it, but my question is: how do I edit my Filename? I dont even know where to find it, what less edit it. Alternatively, is it better to write the path directly into the macro?
Any help appreciated.