I know how to export a query out to Excel in VBA.
After the spreadsheet is created, I want to programmatically do the following:
1) Create a "Split" (panes) in the spreadsheet. Coordinates would be at cell A4.
2) Freeze the panes.
This would be the equivalent of choosing Window |Split in Excel, positioning the split to cell A4, then choosing Window | Freeze Panes.