Unable to Step Through VBA code after some methods such as CopyFromRecordset (Excel)

[Dunro]

Hi everyone,



This may be a general or Excel VBA issue, but i'm posting here as my current dilemma is in Access.

I have an issue where sometimes my code runs off "on its own" when I'm trying to step through it. I know it's because I'm doing aomething wrong, and would like to learn more but have no idea what I'm actually looking for.

I stop the code using breakpoints as well as using Control+Break. When I step through, the code "runs on its own" and won't allow me to break after I hit certain methods. (I've had the issue with Excel macros as well...).

Here is a simplified example:

Option Explicit
Private objExcel As Excel.Application
Private objWrkSht As Excel.Worksheet
Public Sub exampleExport(queryDefinitonText As String)


    On Error GoTo Exit_Error
    
    Dim rstReport As Recordset


    Set objExcel = New Excel.Application
    
    objExcel.Visible = True
    Set objWrkSht = objExcel.Workbooks.Add.Sheets(1)
    objWrkSht.Activate


    Set rstReport = CurrentDb.OpenRecordset(queryDefinitonText)
    
    objWrkSht.Range("A2").CopyFromRecordset rstReport  ' *** can't break or step after this line ***
      
    rstReport.Close
    
    Set rstReport = Nothing
    Set objExcel = Nothing
    
Exit Sub


Exit_Error:


        Debug.Print "Error detected."


End Sub

Any ideas why it's going berserk? (I realize TransferSpreadsheet is a preferred method based on this example, but this code ultimately fits into something larger...)

[dr91075]

What, exactly, do you mean by "runs off on its own"? Have you tried holding down the Escape key?

[Dunro]

What, exactly, do you mean by "runs off on its own"? Have you tried holding down the Escape key?

Basically, instead of moving down one line when I press F8 to step through, VBA keeps running the entire process (as if I pressed F5). The escape key doesn't help when you're trying to step through.

Unfortunately, the above code seems to be behaving today so my issue must be something else not in the above code.

[dr91075]

My mistake. I thought you were trying to find an error. I meant using the escape key instead of stepping through. Sorry I wasn't clear. I'm glad you got it worked out.