Open Excel 2003.
Go to Tools -> Macro ->
Visual Basic Editor:

From within the editor go to
Tools -> References and a References – VBAProject box will
appear. In the Look in box click
the down arrow then choose Local Disk ( C: ) then navigate to Program Files
-> Common Files -> Microsoft Shared -> OFFICE11 :

Click on the file named
MSSOAP30.DLL then click Open:

In the References – VBAProject window there should now be an item labeled Microsoft Office Soap Type Library v3.0 with a checkmark in the box to its left :

Click OK then close Microsoft
Visual Basic Editor.
Now try the Journal spreadsheet upload process again. Hypothetically it should now work without an error.