Import a list from SharePoint 2010 into an Excel 2010 worksheet

Hello Everyone

I have never used excel for interactions before, so this is completely new territory for me.
I have searched the internet and came up with this code:

Please Login or Register  to view this content.

What do I want to achieve?
Eventually, I want to import a list from a SharePoint into my excel sheet, just as if I would click manually: 'Actions > Export to spreadsheets > Open' in IE and then Copy&Paste it into the sheet.

What is the problem?
I am new to this and the above code throws an error 1004: "The worksheet range for the table data must be on the same sheet as the table being created"

What could be the problem? I have the feeling that it must be possible to import the data this way.
And also, what does "xlSrcExternal" do in the above code? It holds the value = 0.

I'd appreciate your help a lot
Thanks in advance