View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alain-79 Alain-79 is offline
external usenet poster
 
Posts: 16
Default Addin compatibility between Excel 2k3 and Excel 2k7

Hi, in oder to force Excel 2007 to generate Excel 2003 files I have been
using this bundle of code inside an Addin

Workbooks(genSyncQteParam.fileName).SaveAs _
fileName:=CStr(SaveAs_path & SaveAsExcel_sourceName), _
FileFormat:=xlExcel8, _
Password:="", _
WriteResPassword:="", _
ReadOnlyRecommended:=False, _
CreateBackup:=False

but... while running this code under Excel 2k3 I receive a message "Compile
error inside one hidd"n module" ... the problem being on FileFormat:=xlExcel8

Assuming I do need this addin to stay for a while compatible between the two
Ecel versions, what can I do ?

I guess I will be facing same kind of trouble with such line code
ActiveSheet.ExportAsFixedFormat type:=xlTypePDF

Thanks for your help
Alain