Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
fileformat property compatibility
Hi,
I need to distribute an Excel app (with VBA) to users with versions of Excel ranging from Excel 2000 to Excel 2007. The app has to be able to save workbooks in a common format (so something saved in Excel 2000 can be read in 2007 and vice versa. The files must also be able to handle unicode. I tried this: ActiveWorkbook.SaveAs strFolder & strDataWorkbook, FileFormat:=xlExcel7 but it seems to be corrupting the unicode. How can I tell which version of Excel the XlFileFormat constants relate to? Is it possible to (and do I need to) write code that says If I'm running excel version X then use FileFormat1 elseif I'm running excel version Y then use FileFormat2 .. .. .. end if Obliquely related to this, does anyone know how to import .xlsx files using SSIS 2005? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
fileformat property compatibility
Hi GPO
See this page http://www.rondebruin.nl/saveas.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "GPO" wrote in message ... Hi, I need to distribute an Excel app (with VBA) to users with versions of Excel ranging from Excel 2000 to Excel 2007. The app has to be able to save workbooks in a common format (so something saved in Excel 2000 can be read in 2007 and vice versa. The files must also be able to handle unicode. I tried this: ActiveWorkbook.SaveAs strFolder & strDataWorkbook, FileFormat:=xlExcel7 but it seems to be corrupting the unicode. How can I tell which version of Excel the XlFileFormat constants relate to? Is it possible to (and do I need to) write code that says If I'm running excel version X then use FileFormat1 elseif I'm running excel version Y then use FileFormat2 . . . end if Obliquely related to this, does anyone know how to import .xlsx files using SSIS 2005? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Using FileFormat:=xlText | Excel Discussion (Misc queries) | |||
Testing Reverse Compatibility and Compatibility in General | Excel Discussion (Misc queries) | |||
Default Excel FileFormat? | Excel Programming | |||
Fileformat XLText | Excel Programming | |||
fileformat not working with Object | Excel Programming |