Quote:
Originally Posted by macropod
You should close all instances of Excel, then check Task Manager to ensure you don't still have any orphaned Excel sessions running in the background. If you've messed up your code development, it's quite possible such an instance is keeping the workbook open.
Until you have the code running correctly, it's advisable to use:
.Visible = True
instead of:
.Visible = False
|
Hi Paul, as suggested by you, I have made necessary amendments. the code works fine in MS Office 2007 only if I set the xlApp object as visible, i.e. .Visible=True. When I change it to False, the error "Remote Call Procedure Failed" comes. Can you throw some light on it and how can I avoid it?
thanks
Regards