Hello All,
Upfront, I don't know much about VBA programming and am still learning a lot in Excel so please be patient with me. Here is my issue, I was asked to work on a small project at work, the dept needs to export data from Access into an Excel worksheet and count the number of students in each grade per school.
I figured the simplest thing to do would be to create a pivot table. The dept will be doing these counts pretty frequently as they add students to list in Access, I figured recording a macro would simplify things as they can run the macro and it will sort, create the PT and provide a last run date.
When I run the macro I get an error: "Run time error 5 invalid procedure call" code provided below.
Can someone please help me with this problem? What am I doing wrong?
Thank You all in advance.
Please Login or Register to view this content.
Full Code for entire Macro:
Please Login or Register to view this content.
Bookmarks