[Calc] How to reference document name in macro?

Boggle
13 ●6 ●9 ●11

LibreCalc

I wish for it to reference the document name instead of some predetermined, "hard coded" name that is in the macro.

How do I reference the document name here?

20923 ●8 ●32 ●110

Hello,

First load the library:

GlobalScope.BasicLibraries.LoadLibrary("Tools")

To simply get the file name without directories or extension:

sFile = FileNameoutofPath(GetFileNameWithoutExtension(ThisComponent.getLocation()))

To get full path without file extension:

sFile = GetFileNameWithoutExtension(ThisComponent.getLocation())

Refer to the post and library for others.

Comments

https://pastebin.com/6a3b8DHN here is my edited macro. It produces a pdf file, but the file is extension-less. How do I make it output with .pdf ?

Boggle ( 2019-11-13 15:27:59 +0200 )edit

Just add it to what you have already:

args1(0).Value = sFile & ".pdf"

Ratslinger ( 2019-11-14 20:19:37 +0200 )edit

Thanks! That worked. I'm still trying to learn macros in this. From what I understand libreoffice uses a variant of MS basic? Thanks again

Boggle ( 2019-11-14 23:19:09 +0200 )edit

Unfortunate time delay. Was out for a few days and notifications on this site are not working completely at least for me.

No, it is not a variant. It uses StarBasic. Info -> OpenOffice Basic. Also -> Tutorial. For more just Google StarBasic.

Ratslinger ( 2019-11-15 02:53:50 +0200 )edit