Re: Convert XLSX to XLS with OLE?

Here is how you can find solution by yourself:

Start Excel
Press Alt+F11 to start Microsoft Visual Basic
Press F2 to start Object Browser
Enter "SaveAs" in Search Text box and press Enter to search for this method
Select any SaveAs method for class Workbook in the search results to get it params
As you see it need FileFormat so enter this text in the Search Text box and press Enter
Select XlFileFormat and get complete list of all avaiable formats

Comment on Re: Convert XLSX to XLS with OLE?

Replies are listed 'Best First'.
Re^2: Convert XLSX to XLS with OLE? by fish (Novice) on Aug 04, 2009 at 11:07 UTC
Thank you for this detailed description. To be honest I did not know the Object Browser before. This will probably help me a lot in future. Best regards, fish	[reply]