Why can't the compiler find the method getActiveSheet? [closed]
Hello,
On LibreOffice 3.6.2.2 on Linux Mint 14, I try to use
Dim oActiveSheet As Variant
oActiveSheet = ThisComponent.getCurrentController().getActiveSheet()
But when I launch it, the compiler says me that he can find the methode or property getActiveSheet.
How can I correct this?
Thank you
Where do you launch your macro? From what? From sheet of workbook or from basic IDE? What component basic get as ThisComponent?
After some test, the command works. I just comment and uncomment "Option Explicit". Thanks you for your help
Miracle on the level of shamanism :-)
@Primomh -- could you please turn your comment into an Answer so we could use it to resolve this question? (As @JohnSUN notes, the solution does seem a bit like black magic, but if that's what fixed it... :-)
Thanks!