i have a website i need to query, but as i can only look up one term at a time i want to run it through excel and have it auto query the website for about 50 terms and put the result into an excel table.
i figured out how to write a .iqy file but here's the catch... the website in question is coded with unselectable tables.
there are also several search option (ig you can search by name, number, or branch) I only want to search by number and i know the name of that field on the webpage and the table name.
am i SOL? or is there a way to do this.
i figured out how to write a .iqy file but here's the catch... the website in question is coded with unselectable tables.
there are also several search option (ig you can search by name, number, or branch) I only want to search by number and i know the name of that field on the webpage and the table name.
am i SOL? or is there a way to do this.
