[Solved] Dialog in sheet library

[Fraz627]

Need Help with a dialog box macro. I created dialog box and launched from a macro, the location of both was orignally in the MyMacro library. After creation I moved them to the actual sheet library and now the Macro does not work.

I searched the net and found were a subscrper to this forum had the exact problem by no mention was made to the solution.

Attached is my code (which I got from the internet)

Code: Select all

Sub StartDialog1()
    ' Code for initiating and showing the dialog
    BasicLibraries.LoadLibrary("Tools")
    oDialog1 = LoadDialog("Standard", "Dialog1")
    oDialog1.Execute()
End Sub

Any suggestions

[Villeroy]

"My Macros" is the place where global libraries are stored for the current user. It always has one "Standard" library and you can edit these libraries freely.
"OpenOffice Macros" is the place where global libraries are stored for all users of this installation. It comes with some example libraries such as the "Tools" library. You can not edit these libraries easily.
Both places combined are the "GlobalScope" of all libraries that are not embedded in documents. You can not add a "Standard" library to "OpenOffice Macros" because "Standard" exists in "My Macros" already. You can not add a "Tools" library to "My Macros" because "Tools" exists in "OpenOffice Macros" already.

Code: Select all

BasicLibraries.LoadLibrary("Tools")

refers to a "Tools" library in the same document as the calling macro.

If you want to load a GlobalScope library from either "My Macros" or "OpenOffice Macros":

Code: Select all

GlobalScope.BasicLibraries.LoadLibrary("Tools")

[Villeroy]

"My Macros" is the place where global libraries are stored for the current user. It always has one "Standard" library and you can edit these libraries freely.
"OpenOffice Macros" is the place where global libraries are stored for all users of this installation. It comes with some example libraries such as the "Tools" library. You can not edit these libraries easily.
Both places combined are the "GlobalScope" of all libraries that are not embedded in documents. You can not add a "Standard" library to "OpenOffice Macros" because "Standard" exists in "My Macros" already. You can not add a "Tools" library to "My Macros" because "Tools" exists in "OpenOffice Macros" already.

Code: Select all

BasicLibraries.LoadLibrary("Tools")

refers to a "Tools" library in the same document as the calling macro.

If you want to load a GlobalScope library from either "My Macros" or "OpenOffice Macros":

Code: Select all

GlobalScope.BasicLibraries.LoadLibrary("Tools")

[UnklDonald418]

I moved them to the actual sheet library

Assuming you moved them both into the Standard directory of the sheet library try:

Code: Select all

Sub StartDialog1()
' Code for initiating and showing the dialog

DialogLibraries.LoadLibrary("Standard")
oDialog1 = CreateUnoDialog( DialogLibraries.Standard.Dialog1)
oDialog1.Execute()

End Sub