Below is some data created in a VFP Table and COPY TO SpreadSheet.XLS TYPE XL5
Once in the worksheet the Hyperlink can be physically activated by double-clicking in a cell on column B and pressing return. Once activated this then can be copied to every cell in that column. This work fine interactively.

I want to reproduce this using automation. Any ideas? How do I programmatically active the Hyperlink?


Sample of Data in a Worksheet

Column B             Column O                                           Column P
=HYPERLINK(O2,P2)    https://www.questback.com/-63659397-rQqLrOoc	OLDGN@PARK158912.47771
=HYPERLINK(O3,P3)    https://www.questback.com/-63659976-bFmuNuaW	OLDGN@6445.46841
=HYPERLINK(O4,P4)    https://www.questback.com/-63659975-VKqXgRxS	OLDGN@6445.47558
=HYPERLINK(O5,P5)    https://www.questback.com/-63658304-KUBECjHy	OLDGN@PARK219167.46555