Tech support suggested I post my resolution to this problem (I want the output of the .fex to automatically be landscape when it opens in Excel). Some of this I had already found in Focal Point, but I think the key for me was where to put the VBA code. I use WF/Dev Studio 7.6.4 on Windows NT.

1. Create a new Excel spreadsheet.
2. Put a blank cell in both of the first 2 worksheets.
3. Go to the "ThisWorkbook" object of the VBAProject(name of spreadsheet). Without the VBA code
in the right place in the VB Editor, the sheet with the WF output becomes portrait even if you
changed the orientation to landscape (in page layout) in Excel.
4. Add the following code (this example defaults more than just landscape orientation) in the VB Editor:

Private Sub Workbook_Open()
With ActiveSheet.PageSetup
.Orientation = xlLandscape
.PaperSize = xlPaperLegal
.LeftMargin = Application.InchesToPoints(0.5)
.RightMargin = Application.InchesToPoints(0.3)
End With
End Sub

5. Put your cursor in the worksheet you want your WF output to go (which would probably be the first
worksheet).
6. Save the spreadsheet as a regular excel spreadsheet (.xls). Note, you may not have to save it, but
it may be good to do if you want to change this later, instead of starting over from scratch, or
maybe changing the .mht file (I didn't test that).
7. Save the spreadsheet as .mht (Single File Web Page). The .mht needs to be in one of our folders in
the APP PATH.
8. The .fex needs a line like ON TABLE PCHOLD FORMAT EXL2K TEMPLATE 'templatename' SHEETNUMBER 1
(including the single quotes around the name of the template, which is the .mht file). The 1 after
SHEETNUMBER represents the first worksheet.
9. As you can see from my VBA code, we can default other parameters besides just the orientation of
LANDSCAPE. Thus, using Excel VBA and tempplates may still be good to use even after release 7.6.9
if ORIENTATION=LANDSCAPE is the only relevant new feature.

Thanks,

~Mark