Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to open a hyperlink in chrome only.
please suggest a way to write macro.
I have tried below code of VBA, but it is not working.
Sub OpenMyURL()
ChromeLocation = "C:\Program Files (x86)\Google\Chrome\Application\chrome.exe"
MyURL = "https://www.google.com" 'URL that you would like to open; you may also use a variable for this, or a pointer to the location of the URL
Shell (ChromeLocation & " -url " & MyURL)
End Sub
Error is Type Mismatch - Shell.
Please suggest if there is any other way.
why don't you trying achieving it through actions
Agree with the above contributor, if you are using a button object to launch the macro, use the Actions instead:
https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Button2.htm
There are many options from which to choose there and actions are a much better solution than macro, as macros will force a single-thread calculation condition and may cause other timing issues as well, actions are the best solution here.
Regards,
Brett