I have no clue if I can even make something like this but I figure I would ask.
I have a Google sheets file with about 1400 lines of numbers. I have to search for each one on a website, then click a link to open the corresponding page. Is there way to create a script that will copy the cell, paste it into the search bar, then mouse wheel click on the link, then repeat? I'm just not sure where to even start with writing the code.
Any help would be awesome!
Is this even possible? Copy/Paste/Click
Re: Is this even possible? Copy/Paste/Click
Most of this is pretty easy, but clicking on the link might be hard. Actually, I haven't used Google sheets before; I don't know if getting the numbers out of that will be hard. I kinda suspect it will be since there isn't COM integration like Excel. You might need to use Excel instead.
Pasting the number to the search bar is easy, though.
The first step is going to be figuring out how to get the number out. Try seeing what info WindowSpy gives you for the Google Sheets file. If it doesn't give you anything useful, you'll either need to see if there is a predictable sequence of keypresses you can use to get the number into the clipboard, or possibly switch to using Excel.
Pasting the number to the search bar is easy, though.
The first step is going to be figuring out how to get the number out. Try seeing what info WindowSpy gives you for the Google Sheets file. If it doesn't give you anything useful, you'll either need to see if there is a predictable sequence of keypresses you can use to get the number into the clipboard, or possibly switch to using Excel.
Who is online
Users browsing this forum: Bing [Bot], jollyjoe and 289 guests