Thread: Get filename
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tang[_2_] Tang[_2_] is offline
external usenet poster
 
Posts: 4
Default Get filename

i use getopenfilename to get a excel file and open it, and copy certain
range within 2 files.

my problem is i don't know how to switch within 2 windows.

i try to use workbook(filename).activate, but the filename variable include
the path as well.

regards