Code will not work when followed by more code (does work when stepped through)

In this code I am downloading and opening a CSV file from google trends (I call that part one). Hereafter the data is split into two columns and a line graph is made (I call that part two). If the code are to work for you, you'll have to follow the instructions given in the start of the code and putting log-in credentials into the code.

My problem is that the code works just fine when I am stepping through the whole thing using F8. Then the CSV-file/workbook is opened in the line: Invokepattern.Invoke. Part one also works when run seperately.
It does however NOT work when followed by more code in the form below nor if I split up the two parts and call the two subs seperately.

The problem/error occurs in the line in the beginning of part two of the code. The error message is: 'Subscript out of range'. The error makes sense since the csv-file/workbook is not open nor active.
The weird thing here is that when I then press debug and the debugger highlights where the error is found the CSV-file/workbook is opened!

Furthermore! I have found that if I force the code to debug after part one using the line of code: 'Stop', the CSV-file/workbook is then again opened!

Below is the code (Change Format - Menu is an add-in of my own. I have tried both with an without reference to it):

Please Login or Register  to view this content.

Where do you actually get the error?

In the posted code where does part 1 end and part 2 begin?

Declare EndRow as Long.

Does this make a difference?

Please Login or Register  to view this content.

I'm sorry but I can't test your code as I don't have UIAutomationClient, so all I can go on is the posted code.

If the problem is that the sheet reports isn't there, perhaps due to a timing issue, perhaps you should add a check for that.

PS Where do you actually open Report.csv in the code? I can't see any code that does that, but perhaps I missed something.

Is the file always called Report.csv?

If it is, rather than a timed pause, perhaps something like this.

Please Login or Register  to view this content.

Again that's untested but in theory what it should do is loop until a workbook with the name 'Report.csv' is opened in Excel.

I've added DoEvents to allow the system to process other events just as you have in your code when you navigate to the Google login page.

Actually, have you considered adding this when you are navigating to the 'trends' page?

Please Login or Register  to view this content.