Print-to-excel error-excel 2007

manjusree

Hi,

Recently we have upgraded the version of excel from 2003 to 2007. After that, whenever Print-To-Excel is done, the following error occurs.
" Could not invoke the member Add. ........".

When I checked, it is found that Automation variables are showing unknown server. Library 5 and 12 are available in automation server list. Can this problem be resolved by installing some dll files?. Is it an installation error?. Any help would be appreciated.

Thanks,
Manju

Luc_VanDyck

manjusree wrote:

When I checked, it is found that Automation variables are showing unknown server. Library 5 and 12 are available in automation server list. Can this problem be resolved by installing some dll files?. Is it an installation error?. Any help would be appreciated.

Just edit your automation variable so the Subtype points to the latest version of the library ("Microsoft Excel 12.0 Object Library").

kapamarou

Luc Van Dyck wrote:

Just edit your automation variable so the Subtype points to the latest version of the library ("Microsoft Excel 12.0 Object Library").

And for Office 2010 use "Microsoft Excel 14.0 Object Library"

Is Microsoft superstitious :-k

manjusree

Thanks for ur replies. Yeah, that was something related to installation..when we restarted the server, the problrm got resolved.

Thanks and Regards,
Manju