Is there a way to open and activate an excel spreadsheet from an online
source using vba? I am attempting to write a function in one spreadsheet that
calls upon and performs a function on another sheet; unfortunately this is a
spreadsheet from an online site that changes daily.

I know how to open and activate a sheet that is within my own folder, but
this is obviously more complex.