Well, AvisSoft, I already tried your code... but it still doesn't work. I used office xp, and when i try to run your code I got this error message:

Run-time Error: 1004
Application-defined or object-defined error

The error message is in the

appExcel.Workbooks.Open FileName:=App.Path & "\Test.xls"

I tried to chagne the filename but still got the same error message....

And if I changed your code to like this:

appExcel.Workbooks.Add
appExcel.Worksheets("Sheet1").Select

I got error message:

Run-time Error: -2147417848 (80010108)
Automation Error

The error message is at the appExcel.Worksheets("Sheet1").Select line....


I don't know whats wrong with my comp... help me anybody....

thx