Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing save as file format for excel from VB.net
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing save as file format for excel from VB.net
? xlExcel5
39 use the number 39 this might be more preferable: ? xlworkbooknormal -4143 -- Regards, Tom Ogilvy "johnrc" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |