HI All,
I am trying to automate the excel through the teststand. When I am trying to add sheet in any worbook by calling AddSheet method , I am getting following error :
"Old format or invalid type library".(attached is the snapshot of error)
When i googled it , i found that this is known bug when excel is called through visual studio or any other microsoft programs:
below is the link where i found this information:
https://support.microsoft.com/en-us/kb/320369
As per the article , if your excel is in English langugae and the system locale is other than english, it will throw such error.
But I checked the locale of my system..It is english only(control panel .>> Region &Language >> administative >> Language for non unicode programs)
Still I am getting this error.
Is this is known bug with teststand as well?
Also,does anyone have any idea about the remedy for it? apart from what is mentioned in the link(i dont have option to do that ).
thanks
