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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Back
Top