Programatically changing Excel OLE links

Bowman

Hi all,

I have a spreadsheet which points to cells in another spreadsheet, which is also saved into Worksite using the Worksite OLE linking function. Does anyone know how i can programatically (in VB or VBA) change the reference to child Worksite document that is being linked to in the parent document so it references a different worksite document?

I looked on the database and found the flag in the docmaster table (TYPE=5) but there is no reference to the linked documents in there. I assume then that this information is stored in the Excel spreadsheet itself, which Worksite checks when you open the spreadsheet to prompt for the other spreadsheets that need to be opened.


Thanks in advance.