VBA create pivot table in excel 2010 defaulted to 2003 pivot table format

Hello,

I'm using excel 2010 and trying to create pivot tables using VBA, the problem is that the pivot tables being created automatically default to the 2003 format (i.e. data fields are stacked/vertical rather than horizontal. what can I do to make it default to 2010 format when created?

thanks,