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

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

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

2009-08-25 Thread thedoc
I'm looking for an efficient way to download data from Reuters into vba. Downloading into a workbook cell is easy enough, but I want to avoid using reuters links in my spreadsheet, as it slows things down considerably. At the moment I'm using the following code in vba: ReutersData = Application