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
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.
Sincerely,Please Login or Register to view this content.
Leith Ross
Hello Ckb,
Here is another method using the Windows API.
Sincerely,Please Login or Register to view this content.
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks