Type Library Reference (BTXPPanel)

[NicolaasH]

Hi,
I am making an application that will be used by multiple users. I now have the difficulty that I am referring to a type library that is not standard included in Windows. On my own computer I have downloaded and installed BTXPPanel.dll so everything is fine, but when running the file on another computer an error occurs. As far as I know, this library facilitates very basic things, codes like: Chr(10).

1. Have I made programming mistakes that I need this library, is there a way around using it?
2. if not, how can I best make this work for other users?

Thanks!
Nick

 

[PHV]

Why did you reference a Blue Tooth library in your VBA project ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[NicolaasH]

Hmmmm, no doesn't help.

The weird thing is that if I do not have this file installed I (and other users) get the message:

Compile Error: Can't find project or library

and it highlights the Chr(10) method in the code below. I cannot remember how I found out that installing the BTXPPanel would help, however it does solve the problem. I didn't know it was a Bluetooth library.

Any solutions?

Private Sub Workbook_Open()
On Error GoTo ErrorMessage
    AddIns("Analysis ToolPak").Installed = True
    AddIns("Analysis ToolPak - VBA").Installed = True
    Calculate
    Application.WindowState = xlMaximized
    Worksheets("Home").Activate
    Worksheets("Home").Range("B6").Select
    MsgBox ("Welcome to the Project!" & Chr(10) & "Please select the correct month on the Home page")
ErrorMessage:
If Err.Number <> 0 Then
    Msg = "Error # " & Str(Err.Number) & " was generated by " _
            & Err.Source & Chr(13) & Err.Description
    MsgBox Msg, vbCritical, "Error", Err.HelpFile, Err.HelpContext
End If

End Sub

The error handler in the method is not activated.

 

[ck1999]

Your code works fine in excel 07.


ck1999

 

[PHV]

Untick the reference to this library in your project.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886