Hi,
Just to clarify my post.
I'm looking for a way to access Reuters data in a VBA module (not a
spreadsheet cell).
The RtGet function works perfectly well in a spreadsheet cell, however
when I try to use it in a function/sub in a vba module, it doesn't
work.
The workaround I'm using involves using 'application.evaluate()'. This
mimics the function a spreadsheet cell, and evaluates the argument as
though you had just typed it into a cell.
However, I'm looking for a less crude and more efficient alternative
to this.
thedoc
zheng yu wrote:
> Hi
>
> I am using vba and Reuter data everyday. I didn't get your question that
> clearly.
>
> normally I would use =RtGet("IDN",RIC,FieldName) to get live market
> data.
>
> I've never use application.evaluate(RIC) ...what is for?
>
>
>
> On Thu, Aug 27, 2009 at 10:15 AM, thedoc <brooks...@googlemail.com> wrote:
>
> >
> > Hi,
> > I'm looking for a way to link to Reuters live market data in vba.
> >
> > Doing this from a workbook is relatively straightforward, however I
> > don't want any links in my spreadsheet as this slows things down
> > considerably.
> >
> > Currently, I'm using the following vba code:
> >
> > Application.Evaluate ("Reuters Code")
> >
> > where "Reuters Code" represents the reuters code (RIC) for the
> > specific market data I'm interested in.
> >
> > However, this doesn't always work, so I'm looking for a more direct
> > and efficient way to do this.
> >
> > Any Thoughts?
> >
> > >
> >
--~--~---------~--~----~------------~-------~--~----~
----------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 5,200 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
-~----------~----~----~----~------~----~------~--~---
