mcarlton 0 Posted August 9, 2018 I am having trouble copying in from last years league settings. I have them both in the same directory and i've renamed the 2017 file to draft_buddy_football_2017_1.0.xlsm. I get a visual basic run-time error "1004" Sorry we couldnt find C:\Cheatsheet Compiler\2018\draft_buddy_football_2017_1.0.xlsm. Is it possible it was moved, renamed or deleted? And yes I have the Old buddy name as draft_buddy_football_2017_1.0.xlsm and the old buddy year as 2017. Please help. Share this post Link to post Share on other sites
Mike MacGregor 20 Posted August 9, 2018 Hi mcarlton. Have you tried having both files open in Excel at the same time? Sometimes Excel is finicky and it is necessary to have the prior year file open so it is easier for the current year file to find the prior year file. Share this post Link to post Share on other sites
mcarlton 0 Posted August 9, 2018 I tried without success. Btw its O365, Win10 Share this post Link to post Share on other sites
mcarlton 0 Posted August 9, 2018 Nevermind I figured it out. I had renamed my old sheet as: draft_buddy_football_2017_1.0.xlsm.xlsm Working now. Thanks. Share this post Link to post Share on other sites
Mike MacGregor 20 Posted August 9, 2018 Ah, makes sense. I sometimes wonder why it is so important for Windows to hide the file extension on us. Just makes things more confusing. Share this post Link to post Share on other sites