Chance1234
New Member
- Joined
- May 6, 2002
- Messages
- 5
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