Save Pivot Table Drill Down automatically to new workbook

[halfpint123]

Hi

I use the following VBA code to open a pivot table drill down into a new workbook: (i.e. drill down does not open as a new sheet in the main workbook)

Please Login or Register  to view this content.

What I really want is to for the drill down to export to a new workbook then save it's self to my desktop automatically. Without ever seeing the new open workbook. i.e. happen in the back ground.

Also would be niece for the saved work book called be named what is in cell B2 of the new workbook.

Is this possible?

Thanks