I got an issue where using [VB6 + Excel 2003 + Office 2007 Compatibility Pack] to open *.xlsx (Excel 2007) file returns me the following error:-
Here is the sample code to open the file:-This file is not in a recognizable format.
• If you know the file is from another program which is incompatible with Microsoft Office Excel, click Cancel, then open this file in its original application. If you want to open the file later in Microsoft Office Excel, save it in a format that is compatible, such as text format.
• If you suspect the file is damaged, click Help for more information about solving the problem.
• If you still want to see what text is contained in the file, click OK. Then click Finish in the Text Import Wizard.
However the same method is applicable for Word 2003 to open *.docx file.Code:Excel.Workbooks.open "<xlsx file>"
Another thing is the issue is only happen when open via VB6.
It has no problem to open normally by user (double click .xlsx file and it will convert accordingly if compatibility pack installed)
Is it a limitation or for security reason the feature is blocked?
Appreciate much if get feedbacks...