+ Reply to Thread
Results 1 to 7 of 7

VBA stopped stepping through list and does not update summary report

  1. #1
    Registered User
    Join Date
    12-31-2012
    Location
    Florida
    MS-Off Ver
    Excel 2016 - 365
    Posts
    54

    VBA stopped stepping through list and does not update summary report

    I finally got a the single stock query version of this code working perfectly, but converting the VBA from GOOGLE historical data download for multiple stocks, well that stopped working. No surprise there! The download portion of the code works fine, but it runs through the code and ends on the first query without pasting the data into the cells of the SummaryReport's next available line. Not sure as to what I did to the step process. I have spent 2 days playing around with the code with no success. As for the adding data to the SummaryReport, has not worked since converting from COOGLE

    The process:

    Sub BarchartDataSummaryReportDownload()
    Call ConvertArrayToValues [cut and pastes an Array data into plain cell values]
    Call CopyToSummaryReportBulk [copies content from worksheet "BackTest" cells AS8 through BC8 to next available row in SummaryReport worksheet]

    I know that the code is probably not the best, but I did have it working once
    Thanks in advance
    Don

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: VBA stopped stepping through list and does not update summary report

    Don

    Why do you have Step 200 here?
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    12-31-2012
    Location
    Florida
    MS-Off Ver
    Excel 2016 - 365
    Posts
    54

    Re: VBA stopped stepping through list and does not update summary report

    I had to add that to the code because GOOGLE would stop my automated requests when it hit a limit that they had. After adding that code I never had an issue again. I need to remove that code.
    Thanks
    Don

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: VBA stopped stepping through list and does not update summary report

    Don

    You have 2 loops here, which one is that's supposed to be looping through the stock symbols?
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    12-31-2012
    Location
    Florida
    MS-Off Ver
    Excel 2016 - 365
    Posts
    54

    Re: VBA stopped stepping through list and does not update summary report

    Thanks Norie,

    I went back over the code and commented out the loop for GOOGLE records. The STOCK SYMBOL loop successfully steps through each of the symbols in the worksheet. Thank you.

    That leaves the getting the data from each stock query in worksheet "BackTest", cells AS8 through BC8 into the worksheet "SummaryReport", next new row, starting with ROW#2. I believe the issue is in the CopyToSummaryReportBulk.

    Thanks
    Don
    Last edited by Mustang65; 09-26-2018 at 08:43 PM.

  6. #6
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: VBA stopped stepping through list and does not update summary report

    Don

    Perhaps something like this?
    Please Login or Register  to view this content.
    I've offset the destination a little to provide a little room between the sets of data, if you don't want/need that remove Offset(2).

  7. #7
    Registered User
    Join Date
    12-31-2012
    Location
    Florida
    MS-Off Ver
    Excel 2016 - 365
    Posts
    54

    Re: VBA stopped stepping through list and does not update summary report

    PERFECT!!!!
    I just adjusted the offset and it works like a charm.
    Thank you so very much. The program is up and running again.
    Don

+ 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. Summary Table report from list of items with grade?
    By richyrich92 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-02-2016, 12:43 PM
  2. Auto-update summary list when text has not appeared before
    By celinel in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-07-2016, 02:03 AM
  3. [SOLVED] VBA Help : Update Summary Spreadsheet from multiple excel transmital list
    By rxk in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-14-2016, 11:56 PM
  4. Replies: 0
    Last Post: 10-14-2015, 12:53 PM
  5. Convert Detailed Time Attendance report from Biometrics to Summary Report
    By firescorpio in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-02-2013, 02:48 AM
  6. Form Email from Report, Only if Report summary sheet lists Acct for that Sales Rep
    By lukep10 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-28-2008, 01:38 PM
  7. Stepping through an autofiltered list
    By Stefi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-25-2005, 08:53 AM

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