PC Review


Reply
Thread Tools Rate Thread

Can I use VBA to copy from excel and paste

 
 
MikeZz
Guest
Posts: n/a
 
      12th Nov 2009
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


 
Reply With Quote
 
 
 
 
Joel
Guest
Posts: n/a
 
      13th Nov 2009
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
>
>

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel cut/Paste Problem: Year changes after data is copy and paste =?Utf-8?B?QXNpZg==?= Microsoft Excel Misc 3 9th Dec 2005 05:16 PM
Copy & Paste Object without using the Excel Copy Paste functions =?Utf-8?B?R2Fueg==?= Microsoft Excel New Users 0 10th Mar 2004 07:06 AM
Copy & Paste Object without using the Excel Copy Paste functions =?Utf-8?B?R2Fueg==?= Microsoft Excel Misc 0 10th Mar 2004 07:06 AM
Re: Copy/Paste in Excel prints highlighted cells and does not paste Debra Dalgleish Microsoft Excel Misc 0 30th Jul 2003 11:59 PM
Re: Copy/Paste in Excel prints highlighted cells and does not paste Dave Peterson Microsoft Excel Misc 0 30th Jul 2003 11:08 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:51 PM.