How to develop a excel Add in

svv 26 Reputation points

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

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,557 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,653 questions
0 comments No comments
{count} votes