Changing save as file format for excel from VB.net

[johnrc]

Hi,
Can anyone help please.
I am trying to change the save as in Excel through VB.net from a csv type back to an xls. I have attached the code below that i am using but it fails to run with:-

An unhandled exception of type 'System.IO.IOException' occurred in microsoft.visualbasic.dll

Additional information: The process cannot access the file "C:\temp\temp.csv" because it is being used by another process.

My Code:-
excelApp.ActiveWorkbook.SaveAs(Filename:="C:\Temp\Temp.xls", FileFormat:=("xlExcel5"), _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False)
excelApp.Visible = True

Any help appreciated

[Tom Ogilvy]

? xlExcel5
39

use the number 39

this might be more preferable:

? xlworkbooknormal
-4143


--
Regards,
Tom Ogilvy


"johnrc" <[email protected]> wrote in
message news:[email protected]...
>
> Hi,
> Can anyone help please.
> I am trying to change the save as in Excel through VB.net from a csv
> type back to an xls. I have attached the code below that i am using but
> it fails to run with:-
>
> An unhandled exception of type 'System.IO.IOException' occurred in
> microsoft.visualbasic.dll
>
> Additional information: The process cannot access the file
> "C:\temp\temp.csv" because it is being used by another process.
>
> My Code:-
> excelApp.ActiveWorkbook.SaveAs(Filename:="C:\Temp\Temp.xls",
> FileFormat:=("xlExcel5"), _
> Password:="", WriteResPassword:="", ReadOnlyRecommended:=False,
> _
> CreateBackup:=False)
> excelApp.Visible = True
>
> Any help appreciated
>
>
> --
> johnrc
> ------------------------------------------------------------------------
> johnrc's Profile:
http://www.excelforum.com/member.php...o&userid=30267
> View this thread: http://www.excelforum.com/showthread...hreadid=499360
>