Getting an error when trying to make a workbook opened from sharepoint active

[GreenTee]

I'm not sure why.. but when I try to make a workbook that I opened, from sharepoint, to be active it gives me a run time error specifically on this line of code..

Please Login or Register  to view this content.

Here is my full code.

Please Login or Register  to view this content.

Any help would be greatly appreciated!

Thanks in advance.

[GreenTee]

edited the post so trying to get it back on top.

[GreenTee]

Solved it.

For some reason.. excel wasn't recognizing the workbook AS a workbook. For whatever reason. So I just removed xlapp lines.. so the new code looks like this..

Please Login or Register  to view this content.