[Libreoffice-bugs] [Bug 134361] New: activeworkbook.followhyperlink in macro throws error

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=134361

            Bug ID: 134361
           Summary: activeworkbook.followhyperlink in macro throws error
           Product: LibreOffice
           Version: 6.4.4.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: testing1237a-c at yahoo.com

Description:
i have excel macro enabled workbooks that have activeworkbook.followhyperlink
vba command and my libreoffice calc throws 

BASIC syntax error: 
Unexpected symbol:address

https://docs.microsoft.com/en-us/office/vba/api/Excel.Workbook.FollowHyperlink

this link describes microsoft method of using this vba but LO does not work
well with this.


Steps to Reproduce:
open a file containing vba with a button


Rem Attribute VBA_ModuleType=VBAFormModule
Option VBASupport 1
Private Sub CommandButton1_Click()
ActiveWorkbook.FollowHyperlink _
Address:="https://www.microsoft.com/en-in/download/details.aspx?id=7"
End Sub



Actual Results:
BASIC syntax error.
Unexpected symbol: Address.

Expected Results:
link in the button should work. currently the only way to work on the file
containing this vba is to remove the line and then run


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.4.2.2
Build ID: 4e471d8c02c9c90f512f7f9ead8875b57fcb1ec3
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: kf5; 
Locale: en-IN (en_IN.UTF-8); UI-Language: en-US
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200628/9b66f545/attachment.htm>