Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel & Reuters Power Plus Pro
This is more of a Reuters question, but just in case anyone knows...
I have several spreadsheets that use functions provided by the Reuters addins and this all works very well interactively (i.e. I fire up the sheet and hit F9 or run a macro). However, I'd like run this thing as a batch process. So I've written some VB script to start Excel, load the relevant sheet and run a macro. The macro does a full recalc and then prints the sheet as a report to a PDF file. This process works well for sheets that don't rely on the functions in the Reuters Add in, but those that do fail (lots of #VALUE's). The #VALUE's indicate that Excel can't find the relevant function (or it's returning something really bad). I've managed to get this sort of thing going in the past with the 3.0 verion of Power Plus Pro using the same procedure...but I must be missing a trick in the latest one. Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reuters RTGET() Functions | Excel Discussion (Misc queries) | |||
Reuters Link | Excel Worksheet Functions | |||
Using Reuters' RTD quote system in VBA | Excel Discussion (Misc queries) | |||
reuters vba | Excel Discussion (Misc queries) | |||
TS1 Reuters Links in Excel | Excel Programming |