Import Worksheet from One Excel to Another
 

Hi,

I want to import specific worksheets from a closed excel file to a new
excel file.

For example, user clicks a button in FileA.xls.

Certain worksheets (defined in the code) are imported from FileB.xls
into FileA.xls.

I don't want to muck around with data ranges. I just want to copy the
entire worksheet to the new file.

I'm using a DAO to select the excel file.


Regards
Stefano