I use code :

Dim wb as Variant
set wb = Excel.WorkBooks.Open(path)
Windows(FileName).Activate 'FileName is the name of excel file which is
'opened by using Excel.WorkBooks.Open and it's path is path variable

Sheets(1).Select
Range("A1:B3").Select
Selection.Copy

When that code is run, it alert "Copy fail in Automation ..... ".

How could i copy content of a file in Automation?