Error in submit action of HTML button through VBA while importing data from Web

  • I am just user of Excel and try to make Macros for automation of my work. At present I am trying to modify a VBA code which is working for importing data from a web page. Now the information moved to another page along with other information. There is a form containing two text boxes and one Radio button which needs to be filled/checked for populating the desired table. Now to the problem is that submit command is not working (although form page is resetting continuously like data is submitted but table is not populated). Excel sheet is enclosed herewith. Screenshots of the web page is also attached. Please examine and suggest the solution. HOG_new.xlsm