View Single Post
  #1   Spotlight this post!  
Unread 22-03-2013, 01:10
ahartnet's Avatar
ahartnet ahartnet is offline
Registered User
AKA: Andrew Hartnett
FRC #5414 (Pearadox)
Team Role: Mentor
 
Join Date: Jan 2011
Rookie Year: 2005
Location: Houston, Texas
Posts: 202
ahartnet has a reputation beyond reputeahartnet has a reputation beyond reputeahartnet has a reputation beyond reputeahartnet has a reputation beyond reputeahartnet has a reputation beyond reputeahartnet has a reputation beyond reputeahartnet has a reputation beyond reputeahartnet has a reputation beyond reputeahartnet has a reputation beyond reputeahartnet has a reputation beyond reputeahartnet has a reputation beyond repute
Re: OPR after Week Three Events

Ed,

First off, this is an impressive collection of VBA scripts!

Second - when I try to run the refresh data script, I get an error, something about runtime error ' 13' Type mismatch.

I opened v3.0, go to the Dallas page, as thats the one I'm interested in, and make sure that I enable macros and a data connection. When I hit ctrl-shift-P it starts doing a lot of stuff but then stops at that error. When I run the step into the command and do it line by line, it seems it's because it's going through the teams list (which is blank at the time) until it hits the word "match" in C353.

Any tips? Am I missing a step? I don't see anything else suggested in the instructions page.

Thanks!
Andrew
Reply With Quote