Thank you all for your feedbacks. I am trying to solve the problem I raised in:
With the answer above, I can now create a macro like : @auto_download using your_package
Which will automatically download, install and load the package without having an annoying prompt asking me whether I want to install the package (in case it is not installed).