【转帖】open excell
 

open excell..
hi
i have the code as mentioned below and in the picture was working fine in previous macro. but when i tried to copy the same and use it in differnent macro it throws the error.
compile error: invalid use of new keyword and points to the below line.
objxl as new excel.application
can any one guide me how to rectify it.
i had properly added the reference too.
edited: 02/04/2009 at 02:00 pm by sandeep pawar
click for full image