Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Current Excel cell selected
#1
sorry if this already out there but i cant seem to find it.
i'm trying to get the name of the 'selected cell' (eg b2, a14, etc) but i cant seem to get it via that little box at the top right using this info.

Acc a=acc("" "TEXT" win("Microsoft Excel - Time Sheet.xls" "XLMAIN") "Edit" "" 0x1800 0x0 0x20000040)

value=a.Value



thanks.
An old blog on QM coding and automation.

The Macro Hook
#2
Code:
Copy      Help
ExcelSheet es.Init
Excel.Range ac=es.ws.Application.ActiveCell
str s=ac.Address(0 0 1)
;str s.format("%c%i" 'A'+ac.Column-1 ac.Row)
out s
#3
works great.

thanks.
An old blog on QM coding and automation.

The Macro Hook


Forum Jump:


Users browsing this thread: 1 Guest(s)