I created a small test com server in VFP that will return the operating system. It is a small exe.
When I run this code in excel I get a VFP error window stating "Error writing to file.". The VFP com server doesn't use any files so why does this come up? It happens right after I set the object variable to nothing.
Code in Excel:
Private Sub Workbook_Open()
Dim ox As New common
Dim ln As Integer
Dim ls As String
Set ox = CreateObject("common.common"
ls = ox.m_checkos()
ln = MsgBox("OS used " & ls, vbOKOnly, "TEST"
Set ox = Nothing
End Sub
When I run this code in excel I get a VFP error window stating "Error writing to file.". The VFP com server doesn't use any files so why does this come up? It happens right after I set the object variable to nothing.
Code in Excel:
Private Sub Workbook_Open()
Dim ox As New common
Dim ln As Integer
Dim ls As String
Set ox = CreateObject("common.common"
ls = ox.m_checkos()
ln = MsgBox("OS used " & ls, vbOKOnly, "TEST"
Set ox = Nothing
End Sub