GetOpenFilename

  • Thread starter Thread starter Wolfgang
  • Start date Start date
W

Wolfgang

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.
 
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.
 
Back
Top