GetOpenFilename
 

i want to use this method for the user to select a
specific file in their directory. from that file
(ChakahKahn.xls) i need a macro to copy range A1:J10 into
the active workbook (WangChung), onto sheets
("Sheet1").Range("A1:J10"). the worknook ChakahKahn.xls
is not open. TIA.

GetOpenFilename
 

Wolfgang

No you don't. That method should be used when you want the user to select a
file. If you know which file you want to select, then you don't need
GetOpenFileName.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"Wolfgang" wrote in message
...
i want to use this method for the user to select a
specific file in their directory. from that file
(ChakahKahn.xls) i need a macro to copy range A1:J10 into
the active workbook (WangChung), onto sheets
("Sheet1").Range("A1:J10"). the worknook ChakahKahn.xls
is not open. TIA.