Transfer/Copy Data from one workbook to another

Hello all,

I am currently writing macros that will transfer data from a template file, to what is essentially a log file. How does one go about copying data from one workbook to another. I have currently been able to transfer data from one sheet to another using the following code:

Please Login or Register  to view this content.

How could I get this code to write to another workbook. I believe that I read in order to paste another file it must be opened. Is that correct? Any help would be much appreciated.

Thanks,
Scott

Moderator's note: code tags added for you

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Hi Scott,

Instead of trying to read this code, it would help if you just laid out the particular's.

Can we start with what you are trying to accomplish?

There are many ways to go with this that is why we look for specifics up front.

Here is an example I worked up, but with the additional info you posted it will take some more effort (at least for me).

Option Explicit

Please Login or Register  to view this content.

Hi Scott,

Maybe this example can help.

I have a workbook that is called AllYear and two other workbooks (Jan and Feb). I want to extract the exact cell from both Jan and Feb and put them in AllYear. Just put all the files on your desktop and the macro should recognize them.

Please Login or Register  to view this content.

Let me know if things are more clear now.

abousetta