View Single Post
 
Old 03-27-2017, 02:22 AM
Cyberseeker Cyberseeker is offline Windows 10 Office 2010 32bit
Advanced Beginner
 
Join Date: Jun 2016
Posts: 44
Cyberseeker is on a distinguished road
Default Edit Filename Path?

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.
Reply With Quote