PeopleSoft : Excel to CI Issue : User-defined type not defined

This issues comes mostly when using higher versions of windows operating system(Windows 8 and above) or using higher versions of Office (Above office 2007)

Follow the below steps to resolve the issue:

Solution 1:Need to enable macros

                 Step1: In excel to CI template Press Alt+F11

                 Step2: Go to Tools-> References

                 Step3: Select “Microsoft AcitveX Data Objects 6.1 Library”  and “Microsoft DAO 3.6   Object Library” and press OK button and Save the references.

Solution 2: Need to modify VB Script

                 Step1: In excel to CI template Press Alt+F11

                 Step2: In Menu bar go to Debug->Compile Excel to CI template, it will open the code with error

                 Step3: Replace  "DOMDocument" with "DOMDocument60"

                                  Replace "Set xHTTP = New XMLHTTP" with "Set xHTTP = CreateObject("MSXML2.SERVERXMLHTTP.6.0")"

                    Step4: Save the Document and compile again

Note:Some times Solution1 is not enough to resolve the issue Try both the solutions.