excel 2007 open other file and copy

M

Marco

With a macro in a file open an other file and copy cells.
This works in excel 2003 but not in 2007 what's wrong?
I use new file .xlsm error code 9

macro in file name.xlsm

Windows("name2.xlsm").Activate ' ERROR 9
Sheets("1").Select
Range("B6:N6").Select
Selection.Copy

thx
 
B

Bob Phillips

Error 9 means that there is no window with that caption, so you need to open
that workbook.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Top