Example:
Cell A1 in File A is referenced in File B. If both files are open and the contents of Cell A1 in File A was edited the new contents would appear in File B. This would happen without having to Save File A or the operator having to manually tell File B to update. It was also done with the DDE link method, just a simple formula.
Now in Calc File A needs to be saved after editing cell A1. Then in File B you have to go to Edit, Links, Update, Close. I tried to record a macro to handle the steps in File B. I figure if I can give a toolbar icon for my users to click to handle the update in File B they will accept that File A needs saved and these extra steps better than going through all of th steps mentioned.
My problem is that the recorded macro does handle the Edit>Links part but it stops there. It will not do the Update and the Close of the dialog. I am totally new to macros and have only scratched the surface. Can those of you in the know offer me any advice in automating this process??
Here is the code for the macro I tried to create:
Code: Select all
REM ***** BASIC *****
Sub Main
End Sub
sub UpdateLinks
rem ----------------------------------------------------------------------
rem define variables
dim document as object
dim dispatcher as object
rem ----------------------------------------------------------------------
rem get access to the document
document = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")
rem ----------------------------------------------------------------------
dispatcher.executeDispatch(document, ".uno:EditLinks", "", 0, Array())
end sub
