Adding a macro to Excel to download data from the internet?

You know the logic behind Macro? Did you know how to create Macro? I had use it before... For me, i only able to macro it within Excel formula calculation and action...