Hi,
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?
bump?
Hi
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
Thanks
john
I used an OLE field in the end.
The key is the .SetOleLocation member function. This can only be set in the Section_Format or declare WithEvents.
There is a size limit with ole objects of about a page.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.