Save as in Vb.net as excel object

TommyGun

MrExcel MVP

Joined

Dec 9, 2002

Messages

4,202

• Apr 13, 2004

• #2

I think you have the wrong methods assigned to the wrong objects...try this...

Code:

xlsApp = New Excel.Application 
xlsBook = xlsApp.Workbooks.Open(Filename:="D:\test.xls", UpdateLinks:=False, ReadOnly:=False) 
xlsBook.SaveAs(FileName:="D:\commaTEST", FileFormat:="xlCSV")

 

Upvote 0

J

Juan Pablo González

MrExcel MVP

Joined

Feb 8, 2002

Messages

11,959

• Apr 13, 2004

• #3

Nevermind me...

 

Upvote 0

TommyGun

MrExcel MVP

Joined

Dec 9, 2002

Messages

4,202

• Apr 13, 2004

• #4

Juan Pablo González said:

Nevermind me...

Click to expand...

Welcome back from the big bad MS world!!!

 

Upvote 0

J

Juan Pablo González

MrExcel MVP

Joined

Feb 8, 2002

Messages

11,959

• Apr 13, 2004

• #5

TommyGun said:

Juan Pablo González said:

Nevermind me...

Click to expand...

Welcome back from the big bad MS world!!!

Click to expand...

thanks !

 

Upvote 0

TommyGun

MrExcel MVP

Joined

Dec 9, 2002

Messages

4,202

• Apr 13, 2004

• #6

Nice picture by the way.

 

Upvote 0

B

benl

New Member

Joined

Apr 2, 2004

Messages

10

• Apr 13, 2004

• #7

Thanks TommyGun,

But it is still give me that error! Some thing relate to "FileFormat"

if I dont use formatfile then it work but I want save as csv or tab format
xlsBook.SaveAs(FileName:="D:\commaTESTcsv.xls")

Cheers
Ben

 

Upvote 0

D

dk

MrExcel MVP

Joined

Feb 15, 2002

Messages

2,942

• Apr 13, 2004

• #8

Hi,

The xlCSV shouldn't be enclosed in " marks as it's a constant. Try this instead:-

xlsBook.SaveAs(FileName:="D:\commaTEST", FileFormat:=Excel.XLFileFormat.xlCSV)

or alternatively:-

xlsBook.SaveAs(FileName:="D:\commaTEST", FileFormat:=6)

HTH
Dan

 

Upvote 0

B

benl

New Member

Joined

Apr 2, 2004

Messages

10

• Apr 13, 2004

• #9

Thanks Dan,
It's working!

This Forum is the Best !!!!

Cheers
Ben

 

Upvote 0

M

manojyeln

New Member

Joined

Aug 18, 2011

Messages

1

• Aug 18, 2011

• #10

Hello,

I am getting this error:
Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
When i try to save the file using xlbook.save it gets saved in mydocuments as Book1.xls

But when i try to save it as xlbook.saveas(here i pass value as mentioned by you).... it throws an exception which is mentioned above.

I am using Visual Studio 2010, working on framework 4.0 and language is Vb.Net..


Please help me out.

Thanks in advance.

 

Upvote 0