Working sheet Macro file path

users
#1

Hi,

Can anyone tell me how to get the path of current working sheet macros file
or library through macro ?

Thanks & Regards,
HEENA GUPTA

#2

Can you clarify your question? Specifically, are you asking:

1. What is the path to the current document (easy, it is available from ThisComponent)
2. Where are my macros usually stored (also easy, but I would need to look up how to get it, probably from the configuration provider)
3. What is the path to the library that contains the maro that is currently running (no idea if that is possible)

#3

Forwarding Heena's response back to the list.

I don't believe that this is possible, but, if I am wrong, someone on the list may know.

#4

Hi :slight_smile:
If you don't know then i doubt anyone else does! It is vaguely possible
but i just doubt it.

Heena what is your 1st language? It might be good to ask the international
translators list in your own language
L10n@Global.LibreOffice.Org
However it would be even better to find your main language and post
directly to the right list
https://wiki.documentfoundation.org/Local_Mailing_Lists

However, asking on this mailing list aswell is often a good plan.
Regards from
Tom :slight_smile:

#5

Heena

It might be better to rephrase your question to describe the task you're
trying to automate.

Iain