When i record macro in excel to create a pivot table it works fine but when i use invoke VBA and run the script with UiPath , 6 columns are not populated and 5 more are randomly added.
Actually, while recording macro, all the ranges and column values are hardcoded in the VBScript. So, if there are any changes with the range or column numbers, then entire preocess will change.
What I thought is , you have recorded with a excel and using with another one, so all the ranges and the columns are changed, so that it is giving you a inappropriate things @shawnmurray
Could you please try making everything dynamic so that it will work perfectly even if the data changes in the next excel