Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
when I open excel file,changes was undid-excel 2007, compatibility | Excel Discussion (Misc queries) | |||
Multiple Excel addin versions having LaodBehaviour issue at Addin | Excel Programming | |||
Excel 2000 with Compatibility Pack can't Save As Excel 2007 docume | Excel Discussion (Misc queries) | |||
setup project for Excel addin, won't register addin | Excel Programming | |||
Remove Excel AddIn from AddIn List !! Help | Excel Programming |