1. After installing VB6, open the VB6 application, select ActiveX DLL, and click open.
2. Enter and write the function at the place where the script is edited.
3. Change the project name and class name on the Right To EOM and writecellsvalue.
4. Click the file --> generate DLL in the menu bar in the upper left corner.
5. register the DLL file, regsvr32 c: \ Users \ dingfeiwu \ Desktop \ qtp \ EOM. dll
6. register as the utility objects of qtp and run the following reg file.
Windows Registry Editor Version 5.00 [HKEY_CURRENT_USER \ Software \ Mercury Interactive \ quicktest Professional \ mictest \ reservedobjects \ EOM] "progid" = "EOM. writecellsvalue "" uiname "=" EOM "" visiblemode "= DWORD: 00000002
7. After successful registration, restart qtp. You can directly call this function in qtp.
For example, EOM. writecellsvalue "D: \ function \ environmentconfiguration.xls", "sheet2", "pass"
Registered successfully. You can view it in qtp step objects.