Hi guys,
Thanks for all the positive feedback so far - I hope the scouting system works well for all of you.
Quote:
Originally Posted by RookieWookiez
Wow, awesome looking scouting sheet! We're having a bit of difficulties here with the scout input data. Everytime we try to add in an entry, we get "Run-time error '1004'" and doesn't add in the data for us. It says its an application or object-defined error. We're not sure if it's our computer that we're using or if there is some sort of error with the coding.
|
I know you said you figured out the error but can you go into more detail why that error was happening or how? I'd like to know if its something I can fix for future users.
Quote:
Originally Posted by Carter12s
It is not super important, but has anyone found a workaround for this, or do I just need to get some more computers with excel 2003?
|
I believe the excel object structure and thus the coding for VBA for excel has changed between excel 2003 and excel 2007. I coded everything in excel 2003 so I know it will work for that. I can't guarantee results for any other version of excel and I probably won't get around to figuring out what has changed between the two versions to upload a 2007+ compatible scouting file.
Regarding the password for the code and the sheets, I'm pretty reluctant to reveal it because of how sloppy/non-intuitive the code is in terms of readability. Maybe if I get around to commenting at some point...?
