Reference this thread which I monitored closely as it evolved.

I'm using the code that DKenny supplied in that thread to output a recordset to a newly created Excel Worksheet, and the recordset data is displaying just fine. I have questions on formatting.

1. My first column is a number, which by default in Excel, is right justified. I need to left justify it. I thought converting the recordset element to a string before dumping it to Excel would do the trick, but it has not. How do I left justify this number?

2. I need to print the report in Landscape. What would I use ensure this would happen (I know I can do it through the page setup in Excel, but I'd like to pass the Landscape attribute to the worksheet when it gets created.)

3. How do I turn the gridlines off programmatically?

4. I will never know how many records are in the recordset, so I will never know how far down the page the records will go. Regardless of that, however, I need to print two totals two lines below the last line of the worksheet. How would I calculate in what row those totals should go?