Hey there!

So that's basically my problem, I know nothing about programming, but I tried to record a macro importing the data from access to excel and creating a pivot table.

But the problem is that when I execute the macro, I always get an error which I don't understand.

The code I have right now is this one:

Please Login or Register  to view this content.
The error I get is some "Run-time error '5': Invalid procedure or argument", and when I try to debug, the colored code above is what gets underlined with an arrow poiting to the last line. Just one small detail, if i run the macro again, it completes the action as it should.

So my question is: what's wrong with the code, because I've only recorded an action. And second one would be if there's any easier way to do this.

Thanks!