Copy a worksheet throws "Exception from HRESULT: 0x800A03EC."
Thank a lot Nick & James. It works great !
" wrote:
As Nick wrote you only require one instance of Excel. To get around
your activeworkbook problem, set the reference when you open the
workbook then open the new one: IE
appxl.workbooks.open ("Filename")
Book1 = Activeworkbook.name
appxl.workbooks.open ("Filename2")
Book2 = Activeworkbook.name
This should then reference the correct books. You can then use
appxl.Windows(Book1).activate to move back to workbook one etc.
James
i3tech wrote:
Can you explain it please ?. Iam not getting it.
if you open in same instance then how will i get two different workbook
and their worksheets ?. ActiveWorkbook will give me only one workbook to
copy ?
|