![]() In the Visual Basic for Applications window, click the Insert dropdown to select the New Module.Go to the Developer tab from the Excel Ribbon.Follow the steps to open the visual basic editor and write some code there. To open hyperlinks in the Chrome browser, we need to open and write VBA code in the visual basic editor. This is the default file location for google Chrome to install on windows.įor the 2nd part, we can set the hyperlink hardcoded in the VBA code or get it as a cell value from the Excel worksheet. To get the file location of Chrome’s executable file, navigate to Drive C>Program Files (x86)>Google>Chrome>Application. The pathname argument consists of two parts– the 1st part holds the file location of Chrome’s executable program in the computer’s local storage and the 2nd part is for setting the hyperlink to open. ![]() Here, we need to correctly configure the pathname of the hyperlink to open it in the Chrome browser. The Shell function is used to run an executable program using its file location from inside a VBA code. 3 Examples to Open Hyperlink in Chrome Using VBA in Excel
0 Comments
Leave a Reply. |