Macro to pull from different applications

  • Thread starter instereo911 via OfficeKB.com
  • Start date
I

instereo911 via OfficeKB.com

Good Afternoon,

I wanted to see if there was any way to set up a function (or macro) to copy
a cell and then go to a different application and copy information from that
application. Once it copys from the other application it will come back to
excel and paste it. This will happen about 4 or 5 different times.

Example:

Copy cell A1 ---> go to another application and paste --> Copy CC1
information ---> Back to excel and paste in A2 ---> Copy A1 ---> go to
another application and paste --> Copy CC2 information --> back to excel and
past in A3 ---> etc. etc.

Is this possible..(hopefully not complicated)

Thanks again for everything everyone.
 
B

Barb Reinhardt

Which applications do you want to copy things from? I've done some copying
back and forth between Excel and PowerPoint using macros and it wasn't a
trivial matter.
 
I

instereo911 via OfficeKB.com

Barb said:
Which applications do you want to copy things from? I've done some copying
back and forth between Excel and PowerPoint using macros and it wasn't a
trivial matter.
Good Afternoon,
Click to expand...
[quoted text clipped - 13 lines]
Thanks again for everything everyone.
Click to expand...
Click to expand...

Barb,

I want to copy from Excel and then go into our companies Mainframe system
(which I think its used as EXTRA!).
 
Top