Featured Post

TNTET 2017 BREAKING NEWS

TNTET 2017 BREAKING NEWS | ஆசிரியர் தகுதித்தேர்வு நடத்த அனைத்து ஏற்பாடுகளும் தயார்...ஓரிரு நாட்களில் முறையான அறிவிப்பு வெளியாகிறது...| விண்ண...

Thursday, October 3, 2013

Excel : Active Method of Range Class Failed

Error Message : Active Method of Range Class Failed

Sympton / Cause of Error:
While importing data using UDIMagic from Excel into Tally, if youmanually open any Excel sheet (the same file or any other excel file), in such situations you may get the aforesaid error.

Notes:
This is due to MDI (Multiple Document Interface) feature of MS Excel wherein a single instance of Excel is opened and hence, if you are working on Excel programmatically using UDIMagic (or any other external application which uses Automation), you must not manually start  Excel or work in Excel simultaneously.

In simple words, you must not manually start Excel while UDIMagic is running. Although, you can open any Excel sheet(s) prior to starting UDIMagic and keep them opened, but should not manually move in Excel sheet or add/edit any data.

No comments: