Excel OLE active cell coordinates

[JohnR]

Hello,
I am trying to determine what the active cell coordinates are in an Excel worksheet, that has been opened by the OLE/COM, and the user has moved the active cell.
Any help would be much appreciated.
Thanks
John

[stanl]

Assuming your Excel Object is something like oXL, then oXL.Activecell.Address - but your post implies the user is in charge not the script, in which case I would suggest writing worksheet code for an Excel event such as OnChange (which doesn't really apply here), or have your script using a callback with a timer to report the active cell, which sounds like a waste.


Maybe provide more detail .

[JohnR]

Thanks, oXL.Activecell.Address solved my problem

[td]

MSFT's documentation for Excel COM Automation objects can be found here:

https://docs.microsoft.com/en-us/office/vba/api/overview/excel