| View previous topic :: View next topic |
| Author |
Message |
hugeidea
General User
Joined: 06 Feb 2006
Posts: 20
|
 Posted: Wed Mar 17, 2010 11:12 am Post subject: table linked by DDE not updated when opened by macro |
 |
|
Hi everybody,
I have linked a table by DDE in a writer document. The table is updated when I open the doc manually. But when the document is opened by the macro (see code) there is no updating of the table. Anyone has an idea?
the code of the macro:
url=converttourl("g:/Dokumente und Einstellungen/Edgar/PV-Anlage/Test_Tabelleverknüpft.odt")
dim myFileProp() as new com.sun.star.beans.PropertyValue
oDocument=StarDesktop.loadComponentFromURL(url,"_blank",0, myFileProp()) |
|
| Back to top |
|
 |
JohnV
Administrator
Joined: 07 Mar 2003
Posts: 8995
Location: Lexinton, Kentucky, USA
|
| Posted: Wed Mar 17, 2010 1:18 pm Post subject: |
|
|
| Try Edit > Links to update. |
|
| Back to top |
|
|
hugeidea
General User
Joined: 06 Feb 2006
Posts: 20
|
| Posted: Thu Mar 18, 2010 11:48 am Post subject: |
|
|
| Once it has worked indeed (edit -link), I remember! But since then I tried to repeat it and everytime I get some unkown figures in the table. It seems to be figures which have been in the table some time ago. But where do they come from? Meanwhile there are really different figures in the original calc table. |
|
| Back to top |
|
|
|
