Excel VBA macros won't even work on the Mac version of Office 2008. So while you could likely get the template of the XLS file itself to load up inside of Pages on the Mac and then transfer it to Pages on the iPad, your macros will be dead.
As of Office 2008 for the Mac, Microsoft dropped VBA support altogether.