Dynamically Changing ole link

Hello,

I have a cr10 report with a ole object that links to an excel document. I need to be able to change which excel document this links to at app runtime. How would i go about this?

Using vb6. Sorry if this isnt the correct place for this.