I am a newbie to Infopath. But, I have yet to work out how, you can export print view to a word file.
I believe you can highlight all data in word and copy/paste-special into excel.
If a Macro is capable of replicating that process, Iam not sure. A Macro at the InfoPath, or Word or Excel is uncertain.
I have not used Macros, since the Mid 90's.
Now, I cannot get my head over the VB code and object oriented programming.
Then, I developed Excel code to automatically extract Mainframe data from a particular site.
Download into Excel and produce u-beaut Pivot tables.