OLEPUSH

[RM_RM]

Hi Gareth,

I have linked my E views graphs to a powerpoint (through linking using paste special and linked objects) and these charts in the ppt need to be updated every week. I want to write a program that can update the graphs in the power point once the graph in the Eviews is updated. For example, suppose I have a graph (graph1) in Eviews and it is linked to a ppt in a separate drive. Once the data in Eviews is updated and the graph in the Eviews is updated (I have done this programming step), what should I do? I see the function olepush but not sure how to use it? Will it work if I simply write 'graph1.olepush' in the program? How do I specify the path to the ppt to make sure that it pushes the graph from E views to the right ppt? Hope I could explain the question clearly

Thanks
RM

[EViews Gareth]

Code: Select all

graphname.olepush

is the only thing you can do from within EViews. It will update any open applications that are currently linked to the graph. If Powerpoint is not open, and doesn't have the file open, it will do nothing.

This is a limitation of OLE, not EViews per se.

It might be possible to have your EViews program create an image file on disk (a .png for example) and then embed that image inside the Powerpoint file. Then when you run your EViews program, it overwrites the file on disk. I don't know enough about Powerpoint to say whether it will then update itself if the source image is changed, but I presume it is clever enough to do that.

[RM_RM]

Hi Gareth,

I guessed so.. And for some reason graphname.olepush is not able to update the charts in the ppt either. However, every time I open the ppt, it prompts for an update, so I need not program that step! :)

Thank you so much!

RM