Logo

Possible problem: Microsoft WinHTTP Services (winhttp.dll)

When this is required?

You need to have Microsoft WinHTTP Services available in Excel if you need to run DB2Excel in Excel model or Valuatum Template in Microsoft Word.

How to take into use?

 
1.    Open MS Excel (or MS Word in Valuatum Template case).
2.    Open Visual Basic editor by clicking Alt + F11 or from Tools - Macro - Visual Basic Editor (picture 1).
3.    Choose Tools - References (picture 2).
4.    Locate Microsoft WinHTTP Services, version 5.1 (or newer) and select it (picture 3). (If you cannot find it, see solution below.) Notice that the selected references are at the top and unselected alphabetically ordered after them.
5.    Click Ok and close the Visual Basic Editor     
 



 

Problem: cannot find the WinHTTP reference

Microsoft WinHTTP Services, version 5.1 (or later) can be found in Windows 2000 Service Pack 3 and later versions. If you cannot find it, your operation system is probably older than this.
You must get a copy of this file manually:
1.    Download winhttp.dll from Valuatum website.
2.    Save the file to C:\WINNT\system32 (or to corresponding Windows folder).
3.    Open MS Excel (or MS Word in Valuatum Template case) and open Visual Basic editor (see above).
4.    Open the References window (see above).
5.    Click "Browse..." and locate the file.
6.    Select the reference you just imported (Microsoft WinHTTP Services, version 5.1).
7.    Click Ok and close the Visual Basic Editor.

In case of further problems, please contact Valuatum.