Correction:

Although I said that the first argument would need to be adjusted
according to what version of access you were using, what I actually
meant was that would have to be adjusted depending on which version of
Excel you would like in output to.

Also I should have explained that the code I pasted in would output
varQuery(intLoopVar) to the sheet varName(intLoopVar) within
"FileName.xls"

My halo keeps slipping.

Nick

Sorry Nick (or anyone), i'm a bit of a wolly when it comes to code

Can you explain this a little more for me?

I have created a command button called 'Export_Tables' and inserted the
following code in the 'On-Click' value:

Private Sub Export_Tables_Click()
Docmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9,
varQuery (intLoopVar), strPath & "Test Export.xls", 0,
varName(intLoopVar)
End Sub

1. I am using Excel 2003 SP2
2. I want to export the following tables: Financial/Stats, Company,
Country, Game Type, Segment, Period Covering, year, Financial / KPI's,
Measure, Data Type and Currency & Format
3. The workbook I'm using at the moment (for testing) is named 'Test
Export'.

Let me know if you need any more info

Thanks