Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon COM /
avatar image
Question by sanedrak · Feb 22, 2017 at 02:54 PM · vbarefresheikon api vbaworksheet

Can I Control Eikon Excel AddIn for refresh a WorkSheet with VBA ??

sam007
SupDev1

People who like this

2 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Alex Putkov. · Feb 22, 2017 at 03:45 PM

Hi @sanedrak,

The answer is yes, and there are two sets of macros to facilitate this.

PLxxxxEventHandler macros are behind the Refresh commands in Thomson Reuters ribbon and refresh both Eikon Excel and TF functions. The four macros are:

1 - Application.Run "PLRefreshAllEventHandler" to refresh functions in all open workbooks

2 - Application.Run "PLRefreshWorkbookEventHandler" to refresh functions in the current workbook

3 - Application.Run "PLRefreshWorksheetEventHandler" to refresh functions in the current worksheet

4 - Application.Run "PLRefreshSelectionEventHandler" to refresh functions in the selected range

The above commands are executed asynchronously.

The following Refresh commands allow for a synchronous refresh to occur (one line of VBA code needs to finish executing before the next line can begin). Note they do not refresh TF functions:

1 - Application.Run "EikonRefreshSelection"

2 - Application.Run "EikonRefreshWorksheet"

3 - Application.Run "EikonRefreshWorkbook"

4 - Application.Run "EikonRefreshAll"

The first two (optional) parameters for all 4 macros above are waitForRefresh(boolean) & timeout, e.g.

Application.Run "EikonRefreshSelection", True, 3000 or Application.Run "EikonRefreshSelection", CBool(Sheet1.Range("A1")), CLng(Sheet1.Range("A2"))

If waitForRefresh is True, code will continue after the timeout in milliseconds even if the refresh isn't done. Both parameters are optional - the waitForRefresh default is true & timeout default is 30000 (30 seconds).

1 - EikonRefreshSelection takes a third optional parameter rangeToRefresh. This is an address (short or external) of the range to refresh.

2 - EikonRefreshWorksheet takes a third optional parameter worksheetToRefresh. This is the name of the worksheet to refresh. It can be in "[Book1]Sheet1" format to refresh a sheet in a workbook that isn't in the foreground. Or just "Sheet1" which will look for the sheet in the ActiveWorkbook.

3 - EikonRefreshWorkbook takes a third optional parameter workbookToRefresh. This is the name of the workbook to refresh.

All 4 macros will return the number of functions refreshed when all completed or timed out when waitForRefresh is true.

Both sets of macros (PLxxxEventHandler and EikonRefreshxxxx) do not require any references to any dlls.

Best regards,

Alex

Comment
sam007

People who like this

1 Show 3 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

avatar image
alexander.litster-consultant · Sep 20, 2018 at 10:17 AM 0
Share

Hi and thanks a lot for sharing these methods.

Is it possible to force a clear of the cache using a similar method ?

Thanks,

Alec

avatar image
REFINITIV
Alex Putkov. ♦♦ alexander.litster-consultant · Sep 20, 2018 at 11:21 AM 0
Share

No, it's not possible. You can clear Eikon User cache by running "Eikon.exe -clearcache -a -commandline". But this operation requires that Eikon is shut down. You cannot perform it while Eikon is running or while Eikon Excel add-in is signed in.

avatar image
alexander.litster-consultant Alex Putkov. ♦♦ · Sep 20, 2018 at 11:26 AM 0
Share

Hi Alex, Ok understood for this.

Thanks for the help and have a good day!

Alec

avatar image
Answer by sanedrak · Feb 23, 2017 at 12:47 PM

thx!!!

Sometimes Reuters showme the text "Stale" into cell of Excel.

Now I can find de text "Stale", and force a refresh!!!!

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
9 People are following this question.

Related Questions

EikonDDA = New EikonDesktopDataAPI [object does not support this property or method]

Synchronous Refresh Methods for VBA in Excel

How to disable automatic TR data refresh in Excel?

How do I trigger a VBA macro from within the TR function in Eikon Excel

VBA AdfinX Real Time Error Message ERROR #360f

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges