| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SaveAs in Excel97-2003 format
I am working in Excel 2000 on a machine which also has Excel 2007 installed.
In a macro this line is causing Excel to crash: bk.SaveAs Filename:=excel_output_file, FileFormat:=xlNormal bk is a workbook and excel_output_file is a string ending with .xls Is there a problem with the xlNormal value? Is there a value which will specify Excel 97-2003 format which would work? (Because I opened the workbook from a .csv file if I leave out the FileFormat parameter it saves in csv format which I don't want.) Grateful for advice. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SaveAs in xlNormal Format | Excel Programming | |||
| Invoice templet Excel97 to 2003 invoice toolbar missing | Excel Discussion (Misc queries) | |||
| Excel 2003 pivot table has less functionnalities than in Excel97 | Excel Discussion (Misc queries) | |||
| Compatibility issue? Excel97/2003 | Excel Programming | |||
| VBA - SaveAs hangs (2003 vs 2k ?) | Excel Programming | |||
Threaded Mode
