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 <[email protected]> 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 > <[email protected]> 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: [email protected] 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
