[archive] Excel Question

[Migrated content. Thread originally posted on 24 March 2009]

Hello
Do we need a new excel.def file to work with Office 2007 spreadsheets with the new extensions (.xlsx, .xlsm) or does the current file still work?

Thanks

I remember there were issues that I had when we went from version 9 to 10 that we had to change the "def" file. But since that point, I haven't had to change it. I'm not trying to use anything new, though. If you're trying to use new features of the object model, you'll need to definitely create a new one.

[Migrated content. Thread originally posted on 24 March 2009]

Hello
Do we need a new excel.def file to work with Office 2007 spreadsheets with the new extensions (.xlsx, .xlsm) or does the current file still work?

Thanks

Yes.
We need to create a new excel.def file.
[ATTACH]401[/ATTACH]

And has to change "@FileFormat" value to "@xlOpenXMLWorkbook" in "SAVEAS" method(Excel 2007 default file format is ".xlsx").


I use "SAVEAS" method with Excel 2003, code like:

           MODIFY EX-WORKBOOK @SaveAs(         
                   BY NAME @Filename WKBK-NAME-GSP,
                   BY NAME @FileFormat @xlNormal,
                   BY NAME @Password NULL,
                   BY NAME @WriteResPassword NULL,
                   BY NAME @ReadOnlyRecommended 0,
                   BY NAME @CreateBackup 0
                   BY NAME @AccessMode @xlShared).




When I use "SAVEAS" method with Excel 2007, code like:

           MODIFY EX-WORKBOOK @SaveAs(         
                   BY NAME @Filename WKBK-NAME-GSP,
                   BY NAME @FileFormat @xlOpenXMLWorkbook,
                   BY NAME @Password NULL,
                   BY NAME @WriteResPassword NULL,
                   BY NAME @ReadOnlyRecommended 0,
                   BY NAME @CreateBackup 0
                   BY NAME @AccessMode @xlShared).



File "open" does NOT need to chagne.

Hello
Do we need a new excel.def file to work with Office 2007 spreadsheets with the new extensions (.xlsx, .xlsm) or does the current file still work?

Thanks