My code is below. It works when I open the link withount using the macro.

When I use:
HTML Code: 
It opens but the pivit tables wont work and all the colors are gone.

When I open it without the CorruptLoad:=xlExtractData I get:

run-time error '1004' method 'open' of object 'workbooks' failed

How can I get this puppy to work and be able to use it like if I were to open it as a link without the macro.

Thanks