You are currently working on UAT
I have a very large Excel file (DB Export) that contains multiple sheets that have different source columns (e.g. Sheet 1/Source column C; sheet 2/source column E; sheet 3/source column F).
I already tried Excelling Studio for this, but I can only define one source column and not different source columns for the different sheets.
Does anybody know about a solution for this?
Paul Filkin | RWS
Design your own training!
You've done the courses and still need to go a little further, or still not clear?
Tell us what you need in our Community Solutions Hub
Paul said:But I get an error trying to run it:
Compile error: Wrong number of arguments or invalid property assignment
I don't know enough about VBA to understand how to fix this... do you have any idea?
Click on the "Debug" button in the error message dialog. This will take you to the macro code and highlight the part of the code where the error occurred.
And then you need to use appropriate analytic- and programming skills to understand what is going on and what the problem can be.
Paul said:But I get an error trying to run it:
Compile error: Wrong number of arguments or invalid property assignment
I don't know enough about VBA to understand how to fix this... do you have any idea?
Click on the "Debug" button in the error message dialog. This will take you to the macro code and highlight the part of the code where the error occurred.
And then you need to use appropriate analytic- and programming skills to understand what is going on and what the problem can be.
Paul Filkin | RWS
Design your own training!
You've done the courses and still need to go a little further, or still not clear?
Tell us what you need in our Community Solutions Hub
Translate
