Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index

Hi Niklas,

thanks a lot for that. I can confirm that these macros do work... I will
analyse them and should be able to adapt them to my needs.

Cheers Jon

----original message----
From: Niklas Johansson <>
Date: Mon, 21 Jul 2014 11:22:53 +0200
Subj: Re: [libreoffice-users] Macro to autoload first recent doc
Let's improve the code a bit...

When we open the registry key we do not need it to be editable so let's 
open it as read only. By default GetRegistryKeyContent opens it as such. 
For some reason LibreOffice complains about named arguments not 
supported for the object, as Jon pointed out to me.

I've changed the key as well to correspond exactly with the key in 
registry. You can search for the key in the registrymodifications.xcu 
file (with the path 
%appdata%\LibreOffice\4\user\registrymodifications.xcu on windows).

I've added a new sub which opens the file and sets some open arguments 
according to what is saved in the registry and if the file is a template 
it should be opened in edit mode. I do not think that the password part 
works at the moment, so that part of the code probably needs some love. ;)

Sub Load1st()
Dim oCUA, oList, oItem As Object
  If Not BasicLibraries.isLibraryLoaded("Tools") Then 
  REM use GetRegistryKeyContent function from the module Tools.Misc
  oList = 
  If oList.hasByName("0") Then
   oItem = oList.getByName("0")
  End If
End Sub

Sub OpenRecentFile(sFileURL as String)
Dim oPickList As Object, oPickListArgs As Object
Dim loadArgs(2) As New
  If Not BasicLibraries.isLibraryLoaded("Tools") Then 
  oPickList = 
  If oPickList.hasByName(sFileURL) Then
   oPickListArgs = oPickList.getByName(sFileURL)
   If FileExists(sFileURL) Then
    loadArgs(0).Name  = "AsTemplate"    'We never want to open a recent 
file as template
    loadArgs(0).Value = false
    loadArgs(1).Name  = "Filter"
    loadArgs(1).Value = oPickListArgs.getByName("Filter")
    loadArgs(2).Name  = "Password"
    loadArgs(2).Value = oPickListArgs.getByName("Password")
    REM use OpenDocument function from the module Tools.Misc
    OpenDocument(sFileURL, loadArgs())
   End If
  End If
End Sub

'I loosely took inspiration from the LibreOffice code 

Niklas Johansson

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.