• Create and open an Excel spread sheet "testOuputCOMEditor.xls" anywhere on the same computer.
  • Open VBA editor window and insert the following code
    		Sub LoadPostman()
        			Set editor = CreateObject("OutputCOMEditor.Document")
    			editor.ShowWindow
    			On Error Resume Next
    		End Sub
    	
    		Sub UnloadPostman()
        			Set editor = Nothing
    		End Sub
    
    		Sub SendText()
    			If Not(editor Is Nothing) Then
            			editor.AddText (ActiveCell.Value)
    			End If
    			On Error Resume Next
    		End Sub
    	
  • Attach each of the above functions to a separate button on the spreadsheet.
  • Check out how it works.
    Note: you have to run the up-to-date C++ executable at least once before the VBA code can find it. The reason: MFC COM implementation checks and/or updates Windows registry each time it runs. The VBA won't find the executable if it is not registered.
  • 1
    Hosted by www.Geocities.ws