Hi,
Can anyone help please.
I am trying to change the save as in Excel through
VB.net from a cs
type back to an xls. I have attached the code below that i am using bu
it fails to run with:-
An unhandled exception of type 'System.IO.IOException' occurred i
microsoft.visualbasic.dll
Additional information: The process cannot access the fil
"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 appreciate
--
johnr
-----------------------------------------------------------------------
johnrc's Profile:
http://www.excelforum.com/member.php...fo&userid=3026
View this thread:
http://www.excelforum.com/showthread.php?threadid=49936