Insert formatted Pivottable from Excel to Word

Hi there

I have been working with VBA for a relatively short time, so forgive me if my question according to VBA is a bit silly.

I have made a template in Word where I have placed bookmarks. My idea was to export from Excel directly to this template. On a weekly basis I import data from CSV to a constant Excel template and from this excel file I would export to a Word document which is a template with selected areas where data from Excel is inserted. I think this process works really well, but I am tired of my pivot tables being imported with visible filters (Filters in pivot tables are placed above even pivot tables). In that case, I have to delete these lines manually in Word. This in itself is not a huge problem, but I'm sure this can be solved quite automatically so that the pivot tables are imported without this "filter line"

I have found the code below on the web which inserts my pivot table just the way I would like it. Unfortunately, I am not competent enough to rewrite my code with the code I found online. Hope you can help me (:

The code below inserts the pivot table perfectly:

Please Login or Register  to view this content.

This Code is my own and inserts the parts from Excel to
Word absolutely perfect, except for the visible filter line from the PivotTable which unfortunately is also included in Word.

Please Login or Register  to view this content.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)