VBA Excel 2016 Crashes ?generates a lot of emf files RRS feed

  • General discussion

  • I use VBA in excel 2016 (64bit) in Win10(64bit)

    It is an update of Excel 2003 with WinXP.

    After 2-6 hours excel crashes.

    Description VBA:

    In VBA every 10 seconds I do a data URL call. Depends of the response data I refresh the backcolor of a Button.

    VBA Code:    

    Public Sub Refresh_BTN()
    If (Failure = True) then
        Btn.BackColor = RGB(255, 0, 0) 'Red 
       Btn.BackColor = RGB(0, 255, 0) 'Green
    End If

    I see every 10 seconds in the map C:\Users\nnn\AppData\Local\Microsoft\Windows\INetCache\Content.MSO a file with extnesion EMF is generated.

    This is a picture of the button i refesh. The filename is a Excel generated, f.a. F10E9E48.EMF.

    I asume this is the problem of the crash.

    How to solve?

    Monday, January 22, 2018 10:46 AM