MIssing References VBA

Question

Question by ryanmacklin · May 28 at 08:02 AM · excel api api requests vba code to refresh an excel sheet thomson reuters

MIssing References VBA

Good morning,

One of my spreadsheets appears to be randomly missing the following References and now no longer works:

I am unable to add them back through the Object Browser as the file-path (highlighted) on my C-Drive does not exist. I didn't delete this previously and so I have no idea how to add these references back so that my sheet will now work?

Thank you.

1590652704637.png (53.2 KiB)

0

10 |1500 characters needed characters left characters exceeded

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

Answer 1 · 2020-05-28T15:32:49Z

REFINITIV

Best Answer

Answer by umer.nalla · May 28 at 03:32 PM

Hi @ryanmacklin

Not an Eikon expert - but the other DLLs should be somewhere in a subfolder of the Eikon folder.

If you click on the other two missing files, it should show the name of the dlls
e.g. Adxoo.dll and Adxfo.dll - please confirm these are the same by clicking the MISSING entries.

On my PC I can see the above two files in
C:\Program Files (x86)\Thomson Reuters\Eikon\Z\Bin

0 Show 1 · Share

10 |1500 characters needed characters left characters exceeded

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

ryanmacklin · May 29 at 03:19 PM 0

Share

Thank you Umer that appears to be my problem resolved!

Answer 2 · 2020-05-28T09:00:09Z

REFINITIV

Answer by chavalit.jintamalit · May 28 at 09:00 AM

Hi @ryanmacklin

I have Eikon Desktop installed on my machine and I can find dex2.dll in these locations:

ahs.png (22.9 KiB)

0 Show 1 · Share

10 |1500 characters needed characters left characters exceeded

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

ryanmacklin · May 28 at 02:47 PM 0

Share

Thank you Chavalit for your reply.

I can see the Dex2 in the Program Files (x86) drive but cannot see the Adfinx Analytics references within this? Can you advise of their location please? To solve the issue is it a matter of referencing this new file-path in VBA?

Thanks again,

Ryan

Answer 3 · 2020-05-28T09:05:34Z

REFINITIV

Answer by umer.nalla · May 28 at 09:05 AM

Hi @ryanmacklin

It is possible that the file location has changed as a result of an Eikon upgrade.

On my PC I can find the Dex2.dll in the following location:

C:\Program Files (x86)\Thomson Reuters\Eikon\Z\Bin\Apps\TR.OFFICE.CORE\0.0.0.0\Bin

This may differ on your PC.

Link to developer guide

If you are unable to locate the required DLL, it may be worth speaking to your local Desktop Support team - as they may have a custom installation of Eikon.

Alternatively, contact the Eikon helpdesk via the Eikon application and they may be able to assist you in confirming the install location etc.

0 Show 1 · Share

10 |1500 characters needed characters left characters exceeded

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

ryanmacklin · May 28 at 02:46 PM 0

Share

Thank you Umer for your reply.

I can see the Dex2 in the Program Files (x86) drive but cannot see the Adfinx Analytics references within this? Can you advise of their location please? To solve the issue is it a matter of referencing this new file-path in VBA?

I spoke to the Helpdesk and they kept referring me back to the Developer Community.

Thanks again,

Ryan

MIssing References VBA

3 Replies

Watch this question

Related Questions