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
|