On 08/19/2014 04:19 PM, Don Daugherty wrote:
For several years I have been using OOo Macros, running under Basic.
Then a few months ago they stopped working, and I am unable to
track-down the source of the difficulty. When I startup a particular
Financial spreadsheet, which should trigger a "Startup" macro,
OpenOffice Basic starts and balks at the first command, which is
GlobalScope.BasicLibraries.LoadLibrary("Calc"), with "Basic runtime
error, An exception occurred,
type com.sun.star.container.NoSuchElementException, Message:."
I don't know where it's looking. What shows up in the file structure
is under
C:\Users\His\AppData\Roaming\OpenOffice.org\3\user\basic\Calc, which
contains a group of .xba basic files.
Ideas, anyone?
That message seems to be saying that a Basic library loaded at the
directory you list does not exist.
Which version of OpenOffice are you running? Did you, perhaps, install a
new version of OpenOffice?
Do you have the directory as listed above? If yes, what files are in
that directory?
I do not have a Windows instance to check against; sorry. I will do some
guessing.
How did you find this path? Do you find this path somewhere in options,
or, did you look on your hard drive?
This may be only marginally useful to you, but, I am currently on a
Linux computer and I have LibreOffice installed, but, I think that the
information will still be useful to you.
I have a file located here:
/home/andy/.config/libreoffice/4/user/basic/script.xlc
I expect that from what you stated, you should have a file here:
C:\Users\His\AppData\Roaming\OpenOffice.org\3\user\basic\script.xlc
If you look at script.xlc, I expect that you will find an entry that
looks something like this:
<library:library library:name="DBUtil"
xlink:href="$(USER)/basic/Calc/script.xlb/" xlink:type="simple"
library:link="false"/>
This is saying that you have a library named Calc and that it is
described in the file script.xlb. (remember that I asked about the files
in that directory above).
Just trying to get a feel for what you have on your machine.
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info: http://www.pitonyak.org/oo.php
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
