Highlighted
Absent Member.
Absent Member.
842 views

[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
0 Likes
2 Replies
Highlighted
Absent Member.
Absent Member.

RE: [archive] Excel Question

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.
0 Likes
Highlighted
Absent Member.
Absent Member.

RE: [archive] Excel Question

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
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.