Correcting the "Can't find project or library" error message

Open Excel 2003.

Go to Tools -> Macro -> Visual Basic Editor:

kitty:Users:stef:Desktop:VBE navigation.jpg

 

 

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 :

kitty:Users:stef:Desktop:pathtoMSSOAP30.jpg

 

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

kitty:Users:stef:Desktop:MSSOAP30.jpg

 

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 :

kitty:Users:stef:Desktop:MSOlibraryv3.jpg

 

Click OK then close Microsoft Visual Basic Editor. 

Now try the Journal spreadsheet upload process again.  Hypothetically it should now work without an error.