how to merge sheet between files

[han]

hello all!
I wonder how do this function in my program: copy a file's first sheet
into another excel file. Currently i am doing copy-and-paste but i wonder if
there is a better way?
thanks!

 

[dvt]

hello all!
I wonder how do this function in my program: copy a file's first
sheet into another excel file. Currently i am doing copy-and-paste
but i wonder if there is a better way?
thanks!

Right click on the sheet tab of the sheet that you wish to move. Select
Move or Copy. Select the destination book and location. Don't forget to
check the Create a Copy box.

Dave
dvt at psu dot edu