{ "key_pair_value_system": true, "answer_rating_count": "", "question_feedback_html": { "html_star": "", "html_star_feedback": "" }, "answer_average_rating_value": "", "answer_date_js": "2024-09-22T13:01:20-04:00", "answer_date": "2024-09-22 13:01:20", "is_docs_available": "", "is_excel_available": "", "is_pdf_available": "", "count_file_available": 0, "main_page": "student_question_view", "question_id": "12519607", "url": "\/study-help\/questions\/im-trying-to-make-an-html-page-that-you-can-12519607", "question_creation_date_js": "2024-09-22T13:01:20-04:00", "question_creation_date": "Sep 22, 2024 01:01 PM", "meta_title": "[Solved] I'm trying to make an html page that you | SolutionInn", "meta_description": "Answer of - I'm trying to make an html page that you can enter data into which will then put the data into an excel sheet after hi | SolutionInn", "meta_keywords": "m,make,html,page,enter,data,will,put,excel,sheet,hitting,submit", "question_title_h1": "I'm trying to make an html page that you can enter data into which will then put the data into an excel sheet after hitting", "question_title": "I'm trying to make an html page that you can enter data", "question_title_for_js_snippet": "I'm trying to make an html page that you can enter data into which will then put the data into an excel sheet after hitting submit in the html page With this code, it successfully opens up the html page, but I can't get the submit button to work or it won't populate the data into the excel sheet Can anybody see what is wrong with the code Thank you in advance Sub Sample () Dim iRow Set objExcel CreateObject ( Excel Application ) Set objWorkbook objExcel Workbooks Open ( C Users danielle cornelius Documents travel xlsx ) Set objWorksheet objWorkbook Worksheets( travel ) objExcel Visible True Set XlSheet objWorkbook Sheets (1) XlSheet Activate iRow 1 With objExcel Do while Cells (iRow, 1) value Cells (iRow, 1) activate iRow iRow 1 Loop Cells (iRow, 1) value Document GetElementsByName ( fname ) (0) Value Cells (iRow, 2) value Document GetElementsByName ( lname ) (0) Value Cells (iRow, 3) value Document GetElementsByName ( tdate ) (0) Value Cells (iRow, 4) value Document GetElementsByName ( leaving ) (0) Value Cells (iRow, 5) value Document GetElementsByName ( returning ) (0) Value Cells (iRow, 6) value Document GetElementsByName ( money ) (0) Value MsgBox Data Added Successfully, vbinformation Document GetElementsByName ( fname ) (0) Value Document GetElementsByName ( lname ) (0) Value Document GetElementsByName ( tdate ) (0) Value Document GetElementsByName ( leaving ) (0) Value Document GetElementsByName ( returning ) (0) Value Document GetElementsByName ( money ) (0) Value End With ObjWorkbook Save ObjWorkbook Close Set objWorksheet Nothing Set objWorkbook Nothing Set objExcel Nothing End Sub fieldset border 00cc00 2px solid padding 10px color green Csharpcorner First name Last name Today's date Leaving date Returning date Money needed ", "question_description": "

I'm trying to make an html page that you can enter data into which will then put the data into an excel sheet after hitting submit in the html page. With this code, it successfully opens up the html page, but I can't get the submit button to work or it won't populate the data into the excel sheet. Can anybody see what is wrong with the code?<\/p>

Thank you in advance.<\/p>