So..I'm writing a macro to enhance an excel document loaded on the
internet. Is there a way to have a macro load the doc from the
internet?

A potential problem is that the document has is behind a pw protected
screen.