Macro to copy from one workbook to a different workbook

http://www.excelforum.com/excel-prog...o-another.html

maybe this is some information for you:

I apologize. I haven't had the time to test this solution to see if it works. I till try to test it tonight and will respond as soon as I have the chance.

Thank you for your response. I appreciate your time.

I've looked at the code in the post you referenced, but I have not been able to figure out how to make it work in my situation.

I've done some reading and have figured out that I should be able to retrieve the data from the source workbook without actually opening it if I use the entire file path. I'm hoping that would solve the problem of having to reactivate the "Test" file. However, I'm too inexperience with VBA to know the syntax necessary to accomplish this. I need to include the name of the worksheet in the source workbook as well as the file path.

I would greatly appreciate any help.

Thank you.
Mikki