Change XLS-File Format via VB .NET

[Ulrich Szagun]

Hi,
I am new to programming Excel. The task seems to be quite simple:
I get an Excel-File in a wrong format (Format 2.1) that is not
readable for VB .NET until I open it in Excel and save it as an Excel
2000 file.

Via VB .NET automation it is no problem for me to open the file in
Excel 2000, change some data and save it again. The problem is that
the file format is still Excel 2.1. How can I save the file as an
Excel 2000-File...

I would be grateful for any hints...

Ulrich Szagun

 

[CoRrRan]

(e-mail address removed) (Ulrich Szagun) wrote in

Hi,
I am new to programming Excel. The task seems to be quite simple:
I get an Excel-File in a wrong format (Format 2.1) that is not
readable for VB .NET until I open it in Excel and save it as an Excel
2000 file.

Via VB .NET automation it is no problem for me to open the file in
Excel 2000, change some data and save it again. The problem is that
the file format is still Excel 2.1. How can I save the file as an
Excel 2000-File...

I would be grateful for any hints...

Ulrich Szagun

Have a look at this code:

ActiveWorkbook.SaveAs FileName:= _
"C:\Temp\Book2.xls", FileFormat:=xlExcel9795

I couldn't find an specific option for saving the file to the current
platform version (your case Excel 2000), but I think that xlExcel9795
should work for your purposes. (As my version (Excel 2003) shows that this
FileFormat will provide a format readable to Excel 97 to 2003.)

HTH,
CoRrRan

 

[Myrna Larson]

I think the format you want is xlWorkbookNormal.

And xlExcel9795 workbook includes both xl95 format and xl97 format. It's
double the normal size.

 

[sheril1981]

i think it becuse of the way of formating excel from vb.net

try this

http://vb.net-informations.com/excel-2007/vb.net_excel_page_format.htm

may it will help u