Possible to save as workbook in different version of Excel

User avatar
sal21
PlatinumLounger
Posts: 4362
Joined: 26 Apr 2010, 17:36

Possible to save as workbook in different version of Excel

Post by sal21 »

I need to save as in my vba Excel a wbook in differente version of Excel format...For example ver. 4, ver. 5 , ver. 2000 ecc...
Existis a table with param to insert into the statement save as?

User avatar
HansV
Administrator
Posts: 78524
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Possible to save as workbook in different version of Exc

Post by HansV »

See XlFileFormat Enumeration (this is for Excel 2007, so it includes the new formats)
Best wishes,
Hans