Output to Excel problem

I am trying to fix a database and excel application, which appears to have been written in Access97, but I am trying to get it working in Access2000.

Basically, this consists of a form that simply accepts a start and end date. This runs various queries on a single table, extracting particular records depending on dates on each record compared to the start and end dates entered into the form.

A macro, using OutputTo, then exports each of these tables as an Excel spreadsheet.

The problem is that one of these spreadsheets should contain just the start date entered in the form, but comes out blank. If I run the query manually it works fine, and gives me a list of cells each containing the start date. This is fine as Excel then works with the date in cell A2.

I've tried everything, but just cannot get the date to appear on the exported spreadsheet.

The only possible clue is that I exported it manually (if memory serves) and it worked, but doing it that way gave me more than one option for the type of excel spreadsheet to export as, whereas the macro only has the one option. Is there any way to change the version of Excel that Access exports the spreadsheets as?

Would be extremely grateful for any help.

If you linked the spreadsheet to a sheet and used vlookup to sort the data to where you want it, would this work for you?

No, the date never gets to a spreadsheet, the spreadsheet produced has a heading of Expr1, but no date. Need the start date from the form to be exported from Access as an Excel spreadsheet.