I'm trying to get data from a web form into excel. The web query doesn't work because the data doesn't pass correctly (I've tried linking the url in excel and also using the "export to excel" option offered on the form itself, neither work).
When attempting to copy/paste the html data, it pastes into the sheet as html but I can't edit any of the text boxes or drop down menus. Even when recording a macro to identify them, the macro refuses to record any interaction with them. I've tried copy/pasting from word into excel, but still can't manipulate the data.
Any idea on how to copy a web form (labels, text boxes and drop downs) and its current text into excel?
When attempting to copy/paste the html data, it pastes into the sheet as html but I can't edit any of the text boxes or drop down menus. Even when recording a macro to identify them, the macro refuses to record any interaction with them. I've tried copy/pasting from word into excel, but still can't manipulate the data.
Any idea on how to copy a web form (labels, text boxes and drop downs) and its current text into excel?