+ Reply to Thread
Results 1 to 2 of 2

Broken Code. Web Data Pull

  1. #1
    Registered User
    Join Date
    01-03-2020
    Location
    U.S.A.
    MS-Off Ver
    365
    Posts
    11

    Broken Code. Web Data Pull

    I had some code that was working fine for weeks and all of a sudden it no longer works anymore. I'm still a novice at vba. Do any of you have an idea as to why this might happen.

    here is the code:
    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Broken Code. Web Data Pull

    Hello JBaum2000,

    Your worksheet "Raw 5" is hidden. I made it visible, cleared it, and ran the macro Five_Year. Data was imported to the worksheet. I am not sure if it is the data you want or in the correct format, but it did import data.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Code help to pull data into Combined tab
    By Delta729 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-13-2016, 12:43 AM
  2. Broken VBA code and debugging has not solved the problem. I am trying to update data.
    By AProkopiou in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-03-2016, 02:24 AM
  3. Replies: 0
    Last Post: 07-08-2015, 06:31 AM
  4. help on vba code to pull data with conditions ,filename,avoid header,unfiltered data
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-27-2013, 05:57 AM
  5. VBA code to pull data between workbooks
    By codesRus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-20-2012, 06:51 PM
  6. Code to Pull Data from a Different File
    By HRBonne in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-26-2010, 08:40 PM
  7. Code to pull data from webpage
    By imimin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-22-2006, 02:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1