copy text between 2 open workbooks via macro

B

bigdaddy3

i would like to copy addresses from 1 workbook to another workbook
automatically using a macro while both are open, there are only 10 cells
involved and i am
already using a macro to call up a worksheet from the first workbook via
button control. Any suggestions or would i have to use copy and paste which
i dont really want to do.
 
D

Duke Carey

You don't need to copy & paste. You can use code along the lines of the
following, where you want to copy the data into Sheet1 of Target.xls

With workbooks("target.xls").worksheets("Sheet1")
.range("A1")=activesheet.range("A1")
.range("B1")=activesheet.range("B1")
etc
End With
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
Enabling Macros message when NO macros in workbook 3
How do I set focus (and select text) on a text box on a modeless userform? 0
Getting Radio Buttons to work, that are inserted via AutoText 0
copy text from 1 workbook to another by macro 0
VBA Coding Help for Beginner 0
Copy worksheet from one workbook to a master workbook 2
Copying Worksheets From Different Workbooks using Marco 4

Top