Hi Narsimha,
First thing is the code you developed is correct but as mentioned parminderdhiman84 confirm that getroproperty is pulling some value before writing to global sheet.
And the other thing that we have to remember is what ever the values that you entered/written to global sheet won't display in the global sheet once the execution is completed, we can find the data only in the "Run-Time Data Table" in the results window. Please let me know still you can get what you desired.
If you are using the code provied by Sathiya, make sure that you have used the correct variable while writing to msgbox (listofalllinks but not sVal )
First thing is the code you developed is correct but as mentioned parminderdhiman84 confirm that getroproperty is pulling some value before writing to global sheet.
And the other thing that we have to remember is what ever the values that you entered/written to global sheet won't display in the global sheet once the execution is completed, we can find the data only in the "Run-Time Data Table" in the results window. Please let me know still you can get what you desired.
If you are using the code provied by Sathiya, make sure that you have used the correct variable while writing to msgbox (listofalllinks but not sVal )
Thanks,
SUpputuri
SUpputuri