Posts by enooo

    I have a procedure in VBA that i've been using for some time now to pull the data set from SQL DB.
    It always took less then 1 min to populate the template but since few days it's been taking more than 10 mins. nothing changed in Database, nothing changed in my vba code either...
    It stucks on :

    Sheets("NEW").Range("A3").CopyFromRecordset rst

    I even upgraded from office 2013 to 2016 but the issue still persists
    Any guesses what could be the reason?

    -the same file with same procedure works fine on my colleagues pc
    -table in question is about 54000 rows in 34 columns
    my code

    [Blocked Image:]