Automate copying from a cell in excel and pasting into a textbox in Chrome

[Grisego]

Hello,

I need help automating a manual task - it is taking a decimal from each of 52 cells in excel and pasting it into each of 52 text boxes on a webpage. I have to do this 240 times, which is quite daunting.

This is what the Excel I am pasting from looks like:\
Week percent

1	0.00%
2	0.00%
3	0.00%
4	1.80%
5	0.91%
6	3.87%
7	1.18%
8	1.81%
9	0.00%

This is what the page and text boxes look like:

How would I go about doing this? (note, it doesn't matter if the format is .91 or .91%)

I am veeery inexperienced, so if anyone can walk me through step by step, you'll be a lifesaver.

 

[richh]

You'd need to know what the textbox names are so you can reference them by tag (or name). Here's a question found online that appears to be similar to your question: Excel Noob Copy Excel Cell to HTML text box

 

[Grisego]

How do I obtain that information?

And once I know that, considering that I only want to input the data but not actually do anything else (such as hit "Ok" or "enter" or "continue" or any other queue at the end of the webpage), do you know what code I can write and how to input it?

 

[Grisego]

Hello,

I need help automating a manual task - it is taking a decimal from each of 52 cells in excel and pasting it into each of 52 text boxes on a webpage. I have to do this 240 times, which is quite daunting.

This is what the Excel I am pasting from looks like:\
Week percent

1	0.00%
2	0.00%
3	0.00%
4	1.80%
5	0.91%
6	3.87%
7	1.18%
8	1.81%
9	0.00%

This is what the page and text boxes look like:
View attachment 43645

How would I go about doing this? (note, it doesn't matter if the format is .91 or .91%)

I am veeery inexperienced, so if anyone can walk me through step by step, you'll be a lifesaver.

You'd need to know what the textbox names are so you can reference them by tag (or name). Here's a question found online that appears to be similar to your question: Excel Noob Copy Excel Cell to HTML text box

So I presume I can get that with Ctrl+U, and then how do I go about automating?

 

[richh]

HTML coding is a whole different ball game than visual basic. I would suggest that you right click the textbox and Inspect (Q in Firefox) the control to see its info. I can't speak to how to code VBA to interact with HTML/CSS coding languages, which is why I provided an alternate source for a solution. Perhaps there are some folks on the forum who know how to get your problem automated, but I figured it'd be better to try to point you in the right direction than just leave you waiting for an answer.

 

[Grisego]

HTML coding is a whole different ball game than visual basic. I would suggest that you right click the textbox and Inspect (Q in Firefox) the control to see its info. I can't speak to how to code VBA to interact with HTML/CSS coding languages, which is why I provided an alternate source for a solution. Perhaps there are some folks on the forum who know how to get your problem automated, but I figured it'd be better to try to point you in the right direction than just leave you waiting for an answer.

Thanks for your help, I've been trying to figure applying that one out and will see how it works out for me! Has some key differences :/