Excel file can't open again ????

[ksor]

I generate an Excel file from within Access 2010 with this code:



Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Set xlApp = CreateObject("Excel.Application")
Set xlBook = xlApp.Workbooks.Add
With xlApp
.Visible = True
.DisplayAlerts = False
.Save TrimFrom("Right", CurrentDb.Name, "") & "Stamtræ.xlsx"
.DisplayAlerts = True
.Quit
End With
Set xlBook = Nothing
Set xlApp = Nothing


But I get a message when opening again that the format or extension is wrong !!!!!

What is wrong her ?

[ranman256]

It could be version. In the access Transferspreadsheet command, use an older version, like 7 or 9 or 12.
save with .XLS extension.

it should open then.

[jwhite]

As an aside, I noticed something odd in your code: "Stamtræ.xlsx"

The "ae" is a single special character - is it that way in your code?

[ksor]

No problem - it's one of the DANISH special characters - and just part of the file name - that's not the problem !
I can make a file in Excel and name it with these special characters - æøåÆØÅ.xlsx - just tried ;-))