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

Hello,

I sure would appreciate if someone familiar with macros could give this
a look and see if this can be made to work.

Thanks


On 1/17/2017, 1:16:52 PM, Tanstaafl <tanstaafl@libertytrek.org> wrote:
> 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