RefireBLP

  • Thread starter Thread starter brian tokar
  • Start date Start date
B

brian tokar

I would like to have a vba code where it automatically poplulates a
table with bloomberg data. Given how long it takes to open the file, I
thought to automate selecting the range and hitting the poplulate
button. My code now is, however, all it does is select the range, it
does not refill it with bloomberg data.

Private Sub Workbook_Open()
Application.OnTime TimeValue("10:55:00"), "filldata2"
End Sub

Sub filldata2()
Application.Run "RefireBLP"
Range("H1:J3").Select
Application.Run "RefireBLP"
End Sub
 
Back
Top