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:
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
Bookmarks