ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can I use VBA to copy from excel and paste (https://www.excelbanter.com/excel-programming/436127-can-i-use-vba-copy-excel-paste.html)

MikeZz

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



joel

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