Chance1234
IS-IT--Management
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
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