Trying to export data from Sharepoint to Excel using VBA

I am trying to export data from Sharepoint 2010 to Excel 2010. I have read-only access to the Sharepoint site. I am getting an error on the "Set objMyList = ..." line. Any idea why? I got this example from another site.

Please Login or Register  to view this content.

Bumpity bump!