Pasting Excel Data Into Multiple Cells of a Webpage

[Jak7217]

Hi All!

Thanks in advance for the help!

On a daily basis, I am taking hundreds of cells of data fromexcel and typing them into a webpage. With the webpage, each field of inputis separated by a tab. Is anyone familiar with a way that I could take thesehundreds of cells and get the data into the webpage? Currently my only thoughtwould be to write a macro that shifts between excel (to copy) and the webpage(to paste), but I have found that the browser sometimes can’t keep up and Imiss cells.

Jak7217

 

[John_w]

This can be done by a VBA macro which automates Internet Explorer (IE) and fills in the web page (form?) fields from Excel cells.

For an example macro, see https://www.mrexcel.com/forum/excel-questions/721353-vba-code-filling-up-online-form.html. Note, however, that that code is specific to the web site in that thread and yours will be different. The code needs to be specific to your web page.

 

[Jak7217]

Thank you, John. This is really helpful!