There is a government website (http://www.mca.gov.in/) where there are details of every Indian public company. I want some data to automatically load in my excel sheet. Problem is that for every query sent to this site, a new window opens. I want to get the 'master data' but unable to write a vba for the same.
Please help me
Please help me