VBA Copying Data From Open Workbook

[tigerfan81]

I have one file that will always be open (master.xls). I will be opening various files and copying the same data range from master.xls to the current open workbook to the same location. Everything seems to be working, except after I copy the range from master.xls. I need some help with the code to activate the open sheet to paste it to because the files names vary that I am pasting to.

There will always be just the 2 files open. I am running Excel 2007 with Windows 7.

Thanks in advance and what a great forum....

 

[Andrew Poulsom]

Which workbook contains the code? If you are opening master.xls from the current workbook, set an object variable to ActiveSheet before doing so. Then you can use that object variable when you want to paste to that sheet.

 

[texasalynn]

OOps - edit read it wrong

Go with Andrew's suggestion