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
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