Bloomberg DDE / Add in question

[Chance1234]

Hi
im working with a spreadsheet that is using Bloomberg DDE to get data, im not to hot on this but can do the formulas in the spreadsheet ok

but ! i want to be able to do it in code,
for example

I have a ISIN Number and i want to use the FIRSecId function

on the spreadsheet it is simply =FIRSecId(adn the ISIN Number) but i want to do that in VBA

if i wanted to use a worksheet funciton in VBA i woud use

Application.worksheetfunction.large(blah blah)

can i do the same here something like

application.addin(Bloomberg DDE).function.FIRSecId(ISIN no)

if so how do i do it >?

Chance

 

[Ivan F Moala]

On 2002-05-07 00:51, Chance1234 wrote:
Hi
im working with a spreadsheet that is using Bloomberg DDE to get data, im not to hot on this but can do the formulas in the spreadsheet ok

but ! i want to be able to do it in code,
for example

I have a ISIN Number and i want to use the FIRSecId function

on the spreadsheet it is simply =FIRSecId(adn the ISIN Number) but i want to do that in VBA

if i wanted to use a worksheet funciton in VBA i woud use

Application.worksheetfunction.large(blah blah)

can i do the same here something like

application.addin(Bloomberg DDE).function.FIRSecId(ISIN no)

if so how do i do it >?

Chance

couple of ways to try but 1st set a reference
to the Addin in your project ie.
VBA > Tools > reference.....then select your
addin.

To run an addin function in VBA

Set test = Application.run("MyAddin!myaddinfunc", "mycriteria")

or

Application.Run "MyAddin!myaddinfunc", "mycriteria"