VBA Open Hyperlinked Spreadsheet

[thorpyuk]

Hi All,

I'm trying to open a spreadsheet stored as a web hyperlink as a tab in my current open spreadsheet... something like:

Dim retval
retval = Shell(Environ$("COMSPEC") & " /c " & "http://ptdbox01/Reports/Pages/Reportviewer.aspx?%2fDocc1181%2fPrice_Policy&rs:ClearSession=true&rs:Format=Excel", 0)




But i'm failing miserably

Any help would be appreciated! Thanks