[Solved] Macro function for Path Name

[Zeko]

I'm a new member and I'm writing a macro where I need to access the Full Path Name of the current Calc sheet. Is there a function to do this? I'm storing sheets in different user folders so I need this so the macro can access the user's name automatically.
Any help would be appreciated. Vista OS.

[JohnV]

Returns a blank string for an unsaved file, otherwise the full path and file name.

Code: Select all

MsgBox ThisComponent.getURL

[Zeko]

Thanks John. Much appreciated. Solved.