![]() ![]() You should also check that you can see Excel (as you have set it visible) and that it is showing the correct workbook - otherwise there is no ActiveSheet to refer to.ĪppExcel is set to nothing in line 13. Pay particular attention to the value of AppExcel, as your error message is telling you that AppExcel is not set when you are referencing it to open the workbook that second time, or alternatively that it cannot access the pivot table of the sheet. Mmm, I think you will need to debug your code by setting a breakpoint at line 5 and stepping through one line at a time.
0 Comments
Leave a Reply. |