Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index

On 02/19/2014 04:08 PM, Bill Martin wrote:
I've tried to implement the simple example shown in the Calc Help system for
the Declare Statement.  Somewhere it expects to find a file: user32.dll but
I have no idea where to find it.  Windows has  many user32.dll files for
it's own use  but presumably none of them are relevant to LibreOffice.The
file does not seem to be included in the DLL files that install with Libre.
So does it need to be downloaded from the web somewhere and manually
installed?I'm just trying to understand how to link Basic to a DLL file so I
can go off and do something more complex.   Thanks.Bill

The point is that the user32.dll file is not relevant to LibreOffice, yet you should be able to call methods in it.

What is your operating system? Obviously it is Windows, so, which version of windows? 7, 8?

What error do you receive if you try to run the following macro?

Declare Sub MyMessageBeep Lib "user32.dll" Alias "MessageBeep" ( Long )
Declare Function CharUpper Lib "user32.dll" Alias "CharUpperA"_
   (ByVal lpsz As String) As String

Sub ExampleCallDLL
  REM Convert a string to uppercase
  Dim strIn As String
  Dim strOut As String
  strIn  = "i Have Upper and Lower"
  strOut = CharUpper(strIn)
  MsgBox "Converted:" & CHR$(10) & strIn & CHR$(10) &_
         "To:" & CHR$(10) & strOut, 0, "Call a DLL Function"
  REM On my computer, this plays a system sound
  Dim nBeepLen As Long
  nBeepLen = 5000
  FreeLibrary("user32.dll" )
End Sub

Andrew Pitonyak
My Macro Document:

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.