S
simonc
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.
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.