VBA Code to run Macro for Bloomberg

[cheesymango]

Hi guys! I'm very new to this so i hope i'm following posting rules! Have a simple question (probably for you experts!) - i have a spreadsheet which task scheduler opens and runs a macro. However, i'm having problems with the macro. I need the spreadsheet which contains a bloomberg addin bdh to "refresh" and save every day. I've went through multiple forums and they say the key to this is to add a time delay as bloomberg needs time to refresh the data? Would anyone be able to create a simple code to refresh the spreadsheet? I haven't dealt with bloomberg before so i do not know how to code this into vba - any help would be much appreciated, thank you!

 

[bsquad]

I not quite sure what you mean by refresh and I haven't ever used bloomberg. But if you are looking for a simple update in your workbook i.e. if you your cell values may have changed due to the macro running then you can try the below. You will have to replace the 0's with the time delay you want - format is (Hours, Minutes, Seconds)

If this isn't what you are looking for hopefully it will point you in the right direction

Sub Calc()
    With ThisWorkbook
        Application.Calculation = xlCalculationManual
        Application.Calculation = xlCalculationAutomatic
    End With
    Application.OnTime Now + TimeSerial(0, 0, 0), "Calc"
End Sub

this is to turn it off

Sub CalcOFF()
    Dim wb As Workbook
        For Each wb In Workbooks
            End
        Next
End Sub