According to my boss at work, an Excel sheet only containing this Macro should be automatically updating (from Bloomberg) whenever it opens:
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
On Error Resume Next
Dim objComment As Object
Set objComment = Target.Cells(1, 1).Comment
If Not objComment Is Nothing Then
If InStr(1, objComment.Text, "Series") > 0 And InStr(1, objComment.Text, "Class") > 0 Then
CommandBars("EwShort").ShowPopup
Cancel = True
Else
Cancel = False
End If
End If
End Sub
Can anyone confirm that this is actually the case? And if not, might there be another way of ensuring automatic update of data from Bloomberg (not involving VBA)?
Thank you!
Bookmarks