Excel Hyperlinks() Problem

Question

Recently the command "Worksheets("R_C_C").Range("Z1:AA2").Hyperlinks(2).Follow" which use to access a Workbook on our website, has started to call up the web browser instead of the Workbook it called up previously. As the next command uses the new workbook, it causes the Sub to goto the error page and stop. Has there been a major change in the functionality of the Hyperlinks routine? I have Microsoft 365 but many of the user have other copies up to 5 years old. The Hyperlink is “http://www.???????.org/uploads/Handicaps/SheetHandicaps.xls”

Answer 1

According to some articles (https://www.bing.com/search?q=excel+workbook+open+url), it is possible to open a workbook using the Web address of the document. Check this fragment:

Application.DisplayAlerts = False
Workbooks.Open "http://....../SheetHandicaps.xls"
Application.DisplayAlerts = True

If it works, maybe you can use it in VBA instead of Follow.

Answer 2

Many thanks for that @Viorel . It worked like a dream. I will have to change how the file path is accessed at other points of the code to make it easier to change the filename if required, but it works.