Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Type Library Reference (BTXPPanel)

Status
Not open for further replies.

NicolaasH

Technical User
Sep 11, 2007
38
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
 
Why did you reference a Blue Tooth library in your VBA project ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
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?

Code:
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.
 
Untick the reference to this library in your project.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top