![]() |
Can I use VBA to copy from excel and paste
My apologizes if this is a duplicate... I can't find the post.
I have an excel macro that processes some data and copies a string to the clipboard. The next step is that I currently manually copy this string to an open website. It's actually a flash program on an open web page. The program itself has a number of tabs (each identically structured) with a couple buttons and a field in which I paste to. Since I have to do this on a regular basis, is there a way to program excel to find the page and input box I want, paste the string, then press a button on the page? Any help would be GREAT! Thanks, MikeZz |
Can I use VBA to copy from excel and paste
Web programming is a little tricky. there is no stadnzrd method to find a
particular box. If you post the URL I can help. You need to look at the source code of the webpage by goiong to IE explorer under menu view - source. then lknow a little html find the box and look for a tag or ID. I do this all the time. If you can't post the URL then I will give you some sample code. "MikeZz" wrote: My apologizes if this is a duplicate... I can't find the post. I have an excel macro that processes some data and copies a string to the clipboard. The next step is that I currently manually copy this string to an open website. It's actually a flash program on an open web page. The program itself has a number of tabs (each identically structured) with a couple buttons and a field in which I paste to. Since I have to do this on a regular basis, is there a way to program excel to find the page and input box I want, paste the string, then press a button on the page? Any help would be GREAT! Thanks, MikeZz |
All times are GMT +1. The time now is 04:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com