Re: [libreoffice-users] Macro/button to update link(s) to external sheet(s)

Doesn't work for me but seems to try to do something.

The article is 4 years old and based on Openoffice - so maybe something
changed and someone here can spot the problem?

Here is the code from the linked article:

REM  *****  BASIC  *****

Sub refreshAllSheetLinks()
   oEnum = thisComponent.SheetLinks.createEnumeration
   while oEnum.hasMoreElements
      oLink = oEnum.NextElement
      oLink.refresh
   wend
End Sub

Sub Main
end sub

On Mon Jan 16 2017 16:23:46 GMT-0500 (Eastern Standard Time), Cley Faye
<cleyfaye@gmail.com> wrote:
> Ok, I can't test this right now, but this page might have an acceptable
> answer: http://blog.louic.nl/?p=622
>
> The part about adding a nice button have a small macro in it. Here it's
> used for linked CSV files, but since the dialog asking to update links
> that's shown when you reload your file is the same, maybe the same
> procedure works.
>
> Other than that I didn't find a quicker way to reload external references
> than file->reload->accept the dialog that asks for refresh :(


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted