"User-defined type not defined"

Hello,

I am new to Excel Programming and I've got compile error says "User-defined type not defined" at the second line of my code (Dim HTTP).
I am trying to create a button which will display in a cell an actual exchange rate of USD and CZK (Czech Crone - my national currency).
Here's what I've tried to writte:

Please Login or Register  to view this content.

Does anybody know what's wrong with that?
Any help would be aprreciate.

Hi jirakst,

You are probably missing a library reference because you are using early binding. In the VBA environment, you probably need: Tools > Reference > Microsoft WinHTTP Services, Version x.x (where x.x is the version number on your computer).

For a discussion of Early Binding vs. Late Binding and examples see:
https://msdn.microsoft.com/en-us/library/0tcf61s1.aspx
http://peltiertech.com/Excel/EarlyLateBinding.html

Lewis

Hello LJMetzger,

thank you for your answer.
I've add the library but insted of compile error received runtime error '424': Object required.

Try the following code that works me (value of 24.416) using Late Binding. That means you can remove the library reference.

Please Login or Register  to view this content.

To prevent typos from ruining days and weeks of work 'Option Explicit' is NEEDED at the top of each code module. This prevents errors caused by missspellings and FORCES every variable to be DECLARED (e.g. Dim i as Integer). http://www.cpearson.com/excel/DeclaringVariables.aspx

Lewis

Dear LJMetzger,

I have copy your code, edit

Please Login or Register  to view this content.

and it works exactly as I was trying to manage.
It will help well my personal project for money managment.
Thank you really much for your help!