Hello all.
I'm not sure if this list is the right place to ask for help with this, I
hope someone can redirect me to an appropriate place.
I have a problem with inked data between some calc documents.
Every month I need to create a new document, and copy the "ending balance"
from the previous month document as "beginning balance" for the new one.
The document computes some credit and debit data and gives a new "ending
balance".
When I try to link the ending-beginning information, when it has more than
two or three different files, openoffice (testing with 2.4.1 and 3.0rc4,
windows xp) gets incredibly slow, and the cells where should show the linked
data just say "#VALUE". Even if the previous file has a value in the
referenced cell.
So, in order to keep every document "separated", I want to create a macro
that "copies" the data form the previous month as text like this:
1.- insert formulas like: "=INDIRECT(CONCATENATE("'";$E$7;$E$8;"'#";I12))"
where I have something like "file:///C:/path/to/" at E7, "filename" at E8
and something like "$sheet.$A$1" at I12 (The cell I want to copy from)
2.- copy and paste special with a macro, to get "text only" data and delete
the "link" formulas
3.- delete "link" to the previous file in order to stop the "refresh-links"
dialog every time I open the file (Edit/Link..., select a link, click on
"break link" button or whatever is called, then click on "ok")
I haven't been able to acomplish the 3rd step (the previous ones are already
working just fine)
If this is the right place, I could add what I've found until now.
Please let me know.
Thank you all in advance
