Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to save an excel file to dBase format? | Excel Discussion (Misc queries) | |||
Save Excel File in Other Format | Excel Discussion (Misc queries) | |||
Why will Excel will not save text format in a .csv file | Excel Worksheet Functions | |||
Save excel file as another format file | Excel Programming | |||
Using Macro to Save xls to txt without changing file format | Excel Programming |