Set Focus to excel application created by Create Object

HI,
I have created an excel application using the Create Object method.After creation how do i setFocus directly to the excel sheet and not to the window i created it from .
Can anybody please help me on this.
Thankyou

Hello Ckb,

Here is the code to switch to the new workbook. The Excel Workbook you create will be the last one in the list of Open Workbooks.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Hello Ckb,

Here is another method using the Windows API.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

This is not working it might show the new application window but it's not activating it. for example if i will write in the end of this sub : "cells(1,1)=888"
it wiil enter this value into the source workbook which runs the code and not to the new application workbook how can I solve it?