Hi!
Is it posible to get a value of V2 cell in active sheet and prompt this in Mesage Box by AHK script?
LibreOffice Calc - how to get a value of V2 cell in active sheet?
Re: LibreOffice Calc - how to get a value of V2 cell in active sheet?
Code: Select all
SetTitleMatchMode, 2
If !WinExist("- LibreOffice Calc ahk_exe soffice.bin") {
MsgBox, 48, Error, Calc is not open. Aborting.
Return
} Else Clipboard := ""
RunWait, %ComSpec% /c WMIC path win32_process where name="soffice.bin" get Commandline |clip,, Hide
ClipWait, 0
If ErrorLevel {
MsgBox, 48, Error, An error occurred while waiting for the clipboard.
Return
} Else RegExMatch(Clipboard, """-o"" ""(.+?)""", p), XL := ComObjCreate("Excel.Application")
Try XL.Workbooks.Open(p1)
Try v2 := XL.Range("V2").Text
XL.Quit()
MsgBox, 64, V2, %v2%