[VBA] Problem Creating An Excel From Access

Hi All,

I am having real problems creating a Excel from Access. I have rea lots of threads, but none seem to address this problem.

OK, so I have windows XP, Access 2003 and Excel all running quite happily on my PC, when I copy Access databases with the verb ".Excel" in it, I can access it and update/extend as needed.

However, I have just created a new piece of VBA code in a new database and the ".Excel" extensions are not present.....

So I have

Sub openReport()
Dim myXL As Excel.Worksheet
Set myXL = createXlWorksheet
.........
End Sub

Public Function createXlWorksheet() As Excel.Worksheet
Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet

Set xlApp = CreateObject("Excel.Application")
Set xlBook = xlApp.Workbooks.Add
Set xlSheet = xlBook.Worksheets.Add

Set createXlWorksheet = xlSheet
Set xlSheet = Nothing
Set xlBook = Nothing
Set xlApp = Nothing

End Function

And in some databases this works correcttly, but this one database,when I type the string "Dim myXL As.Ex" I do not get the "Excel" operator presented, it is just not in the list of object functions..... any ideas?? it's sending me mad!!!!

Thanks