Hi
I have a couple of linked excel tables in a Coredldraw file, and it generally works fine. However, if I delete or add rows, the display gets out of sync. Using the properties window you can see the file link, and the cell reference that is displayed. Is there a way to actually edit that link though and force other cells to be included/removed ?
CJ
tumble weeds, so guessing that's likely a no then?
cadjockey said:tumble weeds, so guessing that's likely a no then?
This forum is in general pretty quiet, and the majority of responses come from other users, not from Corel employees.
I think you're only going to hit the jackpot if your post gets spotted by (1) another user who happens to have experience using linked Excel tables or (2) a CorelDRAW employee who knows a lot about that topic.
no worries, thanks for taking the time..
I follow threads such as this one because I might learn something that will be useful to me in the future. I don't have much experience using OLE to get content into CorelDRAW.
On X5 can be linked table updated Edit - Link - Update
or you can use macro code with OLE.UpdatLink (sample code below testd on CorelDraw X5, select linked table and run macro)
Sub Update_linked_excel_file() Dim OS As ShapeRange Set OS = ActiveSelectionRange If InStr(1, OS(1).OLE.ServerName, excel, 1) > 0 Then OS(1).OLE.UpdateLink End Sub
On higher version of CorelDraw you should look at Object - Link - Update.