Dim FolderPath As String, FilePath As String FilePath=ConvertFromUrl(ThisComponent.getURL())
Now FilePath contains the URL of the file, let's say: /home/guraknugen/SomeFolder/MySpreadsheet.ods Is there a similar way to get the folder name directly? I couldn't find it in ThisComponent, using xray. I can easily get the name of the folder by adding a line like this: FolderPath=Left(FilePath, InStr(FilePath, ThisComponent.getTitle())-2) But that is not what my question is about… I just don't like to calculate things if they are already known… Johnny Rosenberg
