Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Bloomberg DDE / Add in question

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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


  2. #2
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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"

    Kind Regards,
    Ivan F Moala From the City of Sails

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •