$$Excel-Macros$$ Re: Linking to Reuters market data in vba

2009-08-31 Thread thedoc
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

$$Excel-Macros$$ Re: Linking to Reuters market data in vba

2009-08-27 Thread zheng yu
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 wrote: > > Hi, > I'm lo