I have a number of workbook templates hosted remotely on a company
website which I have built launch functions into a customised Menu
Bar so that my staff can easily download these to use in their daily
operations. I have used very basic code to do this which although
it works, is not ideal.

Sub Template()
On Error Resume Next
Workbooks.Add
ActiveWorkbook.FollowHyperlink Address:="http://www.***.com/
[FileName].xls", _
NewWindow:=True
Windows(1).WindowState = xlMaximized
End Sub

Currently this works fine, but as the files are sometimes loaded
without Excel having a current workbook active, I had to add in the
line "Workbooks.Add" or the macro failed to run.

Is it possible to get the code to run without first creating a
redundant workbook?

Any help you can offer would be appreciated.