The following VBA code should do it..
Workbooks.Open Filename:="C:\<path to Excel 3 file>"
ActiveWorkbook.SaveAs Filename:= _
"C:\convert\excel-97.xls", FileFormat:=xlNormal _
, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False
Hope this helps,
Sanjiv
On Apr 2, 2005 2:21 AM, Veena Sarolkar <[EMAIL PROTECTED]> wrote:
>
> Hi All,
>
> I am very new to this forum. But I read the documentaion & came to know that
> we can use HSSF to read & write Excel files.
> But it only supports reading Excel file format of Excel 97.
> Is there any way to read Excel 3.0 file. I have Excel 3.0 file & as I am
> getting it from one URL i cannot use save as to save it in different format.
> Or is there any way to convert this file to Excel 97 programmatically?
> Please help me. This is very urgent.
>
> Regards,
> Veena
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
