Bloomberg DDE / Add in question

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
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple
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"
 
Upvote 0

Forum statistics

Threads
1,213,485
Messages
6,113,931
Members
448,533
Latest member
thietbibeboiwasaco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top