Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling a DLL in MS-Excel
I have the following instructions to call a DLL from Visual Basic. I don't
know how to do this and wondered if someone could assist me or explain to me in layman's terms how to accomplish it. Thanks, Jim This is the calling routine from Visual Basi €˜------------------------------------------------------------------------------------- Option Explicit Private Sub Command1_Click() ' trsm = InputBox("enter legal location") meridian = InputBox("OPTIONAL/enter meridian") state = InputBox("OPTIONAL/enter state XX") Call trsm2ll(trsm, Len(trsm), meridian, Len(meridian), state, Len(state), lat, lng, lerror) MsgBox "latitude=" & lat & " longitude=" & lng & " error=" & lerror & " trsm=" & trsm & " state=" & state & " meridian=" & meridian End Su €˜--------------------------------------------------------------------------------------------------- And this is the Module declaration. €˜-------------------------------------------------------------------------------------------- Option Explicit Public lerror As Integer Public lat As Single Public lng As Single Public state As String * 2 Public meridian As String * 2 Public trsm As String * 16 Declare Sub trsm2ll Lib _ "TRSM2LL.DLL" _ (ByVal trsm As String, ByVal l1 As Long, _ ByVal meridian As String, ByVal l2 As Long, _ ByVal state As String, ByVal l3 As Long, _ lat As Single, _ lng As Single, _ lerror As Integer) The following Visual Fortran DLLs must be present on you computer: DFORRT.DLL DFORMD.DLL MSVCRT.DLL |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling a DLL in MS-Excel
Either the DLLs aren't present on your system and they need to be or they
need to be registered, ex. regsvr32 DFORRT.DLL "Jim" wrote in message ... I have the following instructions to call a DLL from Visual Basic. I don't know how to do this and wondered if someone could assist me or explain to me in layman's terms how to accomplish it. Thanks, Jim This is the calling routine from Visual Basic '------------------------------------------------------------------------------------- Option Explicit Private Sub Command1_Click() ' trsm = InputBox("enter legal location") meridian = InputBox("OPTIONAL/enter meridian") state = InputBox("OPTIONAL/enter state XX") Call trsm2ll(trsm, Len(trsm), meridian, Len(meridian), state, Len(state), lat, lng, lerror) MsgBox "latitude=" & lat & " longitude=" & lng & " error=" & lerror & " trsm=" & trsm & " state=" & state & " meridian=" & meridian End Sub '--------------------------------------------------------------------------------------------------- And this is the Module declaration. '-------------------------------------------------------------------------------------------- Option Explicit Public lerror As Integer Public lat As Single Public lng As Single Public state As String * 2 Public meridian As String * 2 Public trsm As String * 16 Declare Sub trsm2ll Lib _ "TRSM2LL.DLL" _ (ByVal trsm As String, ByVal l1 As Long, _ ByVal meridian As String, ByVal l2 As Long, _ ByVal state As String, ByVal l3 As Long, _ lat As Single, _ lng As Single, _ lerror As Integer) The following Visual Fortran DLLs must be present on you computer: DFORRT.DLL DFORMD.DLL MSVCRT.DLL |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calling a new function Excel gives me #NAME? | Excel Worksheet Functions | |||
Calling VB from Excel | Excel Programming | |||
Calling a VB.NET exe/dll from excel | Excel Programming | |||
Calling Excel from C++ | Excel Programming | |||
Calling a function from within EXCEL | Excel Programming |