I currently have a crystal report (verison 10) with a linked ole object linking to an excel spreadsheet. I need to be able to programmically change the link path at runtime using vb6.
You can do it in crystal by going view -> links ->change source so surely there is a parameter we can pass to the ole object that denotes its source path?

This is exactly what I am trying to do now. I want to pass a variable from the crystal report into the pathname or alternatively link to the excel sheet saved as a BLOB in a database???
any help apreciated