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