VBA Export XML - get outputfile and store as string variable?

I'm using the export xml in excel. I need to build a more complex XML file. What I figured was, I build a table of just "items" which could easily be built by excel by just using the export xml function. What I now need is to nest some items in groups. So I'm going to build a code in VBA which takes the value of an export file and then enclose it in a group tag (so this is multiplied by however many groups).

Now the question is, is there a function that says "give me the output of the Export XML"? Without actually having to export and create a file, and then read the file then copy the values and append the collection of xml output in vba, to produce the final xml.

So just reiterate, I just want to access the XML output without having to create a file. Is it possible? Makes it easy just to do recur through multiple items table and print it. So something like this.

For n = 1 to numberoftables
 <group>
   Get export xml from table(n)   <---- need help on this one
 </group>
next n

trying to achieve a final xml output like below:

<return>
 <form>
   <group>
    <item>
    <item>
   </group>

   <item>
   <item>
   <item>
</form>
</return>