Jump to content
Sign in to follow this  
mcarlton

Copy League Settings

Recommended Posts

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

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

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

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×