Announcement

Collapse
No announcement yet.

Problems downloading csv files into excel using a macro

Collapse
X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
  • #1

    Problems downloading csv files into excel using a macro

    I have been using a VBA macro for a couple of years to download stats from the HQ server. This year, however, I am getting a run-time error (1004) telling me the file can not be accessed. Has anything changed on your server (addresses, policies, etc) that might be causing my problem.

    Thanks
    "Give that fan a contract!" - Rex Barney

    He's throwing a 2 hit shutout and he's shaking me off, can you believe that sh**! Charlie, here comes the deuce; and when you speak of me, speak well. - Crash Davis
    Tags: None
  • #2
    What file are you accessing?

    Comment

    • #3
      Batting_NL_P.csv at the following URL:
      Baseball HQ
      http://www.baseballhq.com/members/tools/projections/proj.php?lg=N&p=B&t=P&f=csv
      "Give that fan a contract!" - Rex Barney

      He's throwing a 2 hit shutout and he's shaking me off, can you believe that sh**! Charlie, here comes the deuce; and when you speak of me, speak well. - Crash Davis

      Comment

      • #4
        When did you last do this successfully? We definitely made some security changes last August that I can recall.

        Comment

        • #5
          It was December that I last successfully downloaded it.
          "Give that fan a contract!" - Rex Barney

          He's throwing a 2 hit shutout and he's shaking me off, can you believe that sh**! Charlie, here comes the deuce; and when you speak of me, speak well. - Crash Davis

          Comment

          • #6
            OK, I'll ask our tech guys to comment here.

            Comment

            • #7
              Not really sure the issue here -- we did do some changes, but going to that URL natively seems to work OK.

              Can you download the file locally then run the script to pull the file in locally?

              Did something change in the file to break the script?

              Comment

              • #8
                Yes, I can import it locally. I'm gonna try some other computers and see if that is the issue. This is the only one with Office 2010. I did remove the protected view restrictions to no avail...
                "Give that fan a contract!" - Rex Barney

                He's throwing a 2 hit shutout and he's shaking me off, can you believe that sh**! Charlie, here comes the deuce; and when you speak of me, speak well. - Crash Davis

                Comment

                • #9
                  Yeah, it must be Excel 2010. Works fine on 2007 on another computer. Thanks for looking in to this, though...
                  "Give that fan a contract!" - Rex Barney

                  He's throwing a 2 hit shutout and he's shaking me off, can you believe that sh**! Charlie, here comes the deuce; and when you speak of me, speak well. - Crash Davis

                  Comment

                  • #10
                    For what it's worth, I use Excel's web query feature.
                    While the individual man is an insoluble puzzle, in the aggregate he becomes a mathematical certainty.
                    --Sherlock Holmes

                    Comment

                    Previous template Next
                    Working...
                    X