DominiConnor
Quant Headhunter
- Joined
- 9/6/06
- Messages
- 1,051
- Points
- 93
This requires the machine to have Bloomberg API installed with a valid license, I believe.Using ActiveX you can also access to Bloomberg servers and pull anything you want into excel or access. This is used rather for historic, static data. For live data you just type functions in excel cells.
I'm really interested in this. I believe many members here have years of experience in VBA, .NET, C++, etc so if they are open to share, I'm all ears.How about creating our own database with C++ and VBA codes so we can exchange them?
The following is what I read from some article online:
"With the arrival of VB.net, API calls are now being phased out. You should only use API calls in VB 6 or earlier"
I've heard that .net is really powerful and useful, but I've never touched it. And I doubt if I even have a basic idea about it. Any suggestions or recommendations on learning .net or, specifically, the VB.net?
I had researched into using .NET to create components for Excel earlier this year (Jan 2006). Here is what I found:
1) Debugging problems is quite tedious. Is the problem in your Excel code, .NET code, or an environmental issue? When .NET code bombs out, the error does not surface.
2) The .NET component is quite slow.
3) I think an additional add-on has to be purchased for Visual Studio.
Jimmy
Has anyone experienced with Excel 2007 and .net ? Are these combos more problematic than excel 2003 and VBA ?