Macro Problems

[Don Daugherty <dd...@sunflower.com>]

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?




---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org

Re: Macro Problems

[Andrew Douglas Pitonyak <an...@pitonyak.org>]

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-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org