Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I am working on some software that integrates an excel workbook. I am having a problem calling the workbook.saveas method. I am developing on XP with excel 2003, but i need this code to work with excel 2000. Apparently excel 2000 requires saveas to have 10 arguments while excel 2003 requires 12 arguments. Ideally I would have something like this: if (System.String.Compare(_app.Version,"10") < 0) { //Office 2000 _wb.SaveAs(_strFilename, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Excel.XlSaveAsAccessMode.xlNoChange,Type.Missing, Type.Missing, Type.Missing); } else { //Office XP _wb.SaveAs(_strFilename, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Excel.XlSaveAsAccessMode.xlNoChange,Type.Missing, Type.Missing, Type.Missing, Type.Missing,Type.Missing); } However I cannot compile this on my XP machine because it says "no overload for method saveas takes 10 arguments" at the first SaveAs call. Help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Modify Macro Code Depending on Excel Version | Excel Discussion (Misc queries) | |||
Excel workbook.saveas freezes program | Excel Programming | |||
Calling a specific version of Access. | Excel Programming | |||
Code in Sub OKButton_Click to trigger actions depending on calling macro | Excel Programming | |||
saveas calling a variable | Excel Programming |