How to develop a excel Add in

Question

How can I make a add-in for excel which will need to call a url based on it. it will open a authentication page there we need to enter valid credentials and based on validation it will redirect some url that url we need to take and use in excel VBA.

Actually I tried invoking browser with shell or process but using this we unable to control browser just able to invoke the url and open browser, based on some actions need pull some data browser in VBA but for this part there no possible solution in VBA(Note1 : for IE browser VBA as services to control but i need to do for edge)
Note2 : I tied with Selenium but i don't want any third party involved here.
So in my explore i found that we can achieve it by excel COM add ins/ excel web add ins. can you please guide me how achieve this. I completely new by to this. So please help me