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 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 > 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+unsubscr...@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
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 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+unsubscr...@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
Re: [libreoffice-users] Macro/button to update link(s) to external sheet(s)
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 :( -- Cley Faye http://cleyfaye.net 2017-01-16 21:45 GMT+01:00 Tanstaafl : > Ok, one more hurdle... > > I tried recording a macro to do this, but it just opens the Edit > Links > window, it doesn't finish (update the links and close the window). > > Anyone have any ideas on how to accomplish this? I really don't want to > tell the boss he'll have to do that manually every time he wants to > refresh the data in his management spreadsheet. > > Thanks > > -- > To unsubscribe e-mail to: users+unsubscr...@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 > -- To unsubscribe e-mail to: users+unsubscr...@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
[libreoffice-users] Macro/button to update link(s) to external sheet(s)
Ok, one more hurdle... I tried recording a macro to do this, but it just opens the Edit > Links window, it doesn't finish (update the links and close the window). Anyone have any ideas on how to accomplish this? I really don't want to tell the boss he'll have to do that manually every time he wants to refresh the data in his management spreadsheet. Thanks -- To unsubscribe e-mail to: users+unsubscr...@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