Saving .xls as a .csv file to open later as .dat

sheiladt · May 10th, 2002, 01:52 PM

I was able to do this until I got a new computer running XP. Now I get an error message and a .csv file with no content is created. When I try to open it in WordPerfect or in Word, of course there's nothing to open.

Is there another way to do this so I can get the .dat file for word processing?

Mark O'Brien · May 10th, 2002, 01:54 PM

Are you doing this manually? i.e. File|Save As and then choosing *.csv or are you looking to get this done using VBA?

sheiladt · May 10th, 2002, 03:54 PM

And, I should have added that I cannot open .txt and .csv files in Excel, either.

sheiladt · Jun 25th, 2002, 10:55 AM

I'm doing it manually, file-save as.

Mark O'Brien · Jun 25th, 2002, 11:38 AM

What's the error message that you're getting?

sheiladt · Jun 25th, 2002, 12:40 PM

The Excel message is:

"filename.txt" cannot be accessed. The file may be read-only or you may be trying to access a read-only location. Or, the server the document is stored on may not be responding.

Mark O'Brien · Jun 25th, 2002, 01:53 PM

Is this file located on a server or another networked machine? (Is this a WinNT or Win2000 server perchance?)

If the answer is "yes", have you tried creating a text file on your machine and have you tried opening that from Excel?

sheiladt · Jun 25th, 2002, 05:16 PM

The file is on a network server, running Novell 4.2

The error message is the same whether I try to open a .txt file in Excel or try to save an .xls file as a .txt

Mark O'Brien · Jun 25th, 2002, 05:49 PM

Yes, but have you tried opening a text file that is stored on your own hard drive in Excel?

I get the feeling that this is a network problem and not a problem with Excel.

sheiladt · Jun 26th, 2002, 11:54 AM

I tried using my local drive and find that I'm able to do just about everything I need to do. I'll present it as a network issue to our systems manager.

Thank you very much for your assistance and for sharinig your knowledge.

May 10th, 2002, 01:54 PM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Are you doing this manually? i.e. File\|Save As and then choosing *.csv or are you looking to get this done using VBA? __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Jun 25th, 2002, 11:38 AM	#5
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	What's the error message that you're getting? __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Jun 25th, 2002, 01:53 PM	#7
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Is this file located on a server or another networked machine? (Is this a WinNT or Win2000 server perchance?) If the answer is "yes", have you tried creating a text file on your machine and have you tried opening that from Excel? __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Jun 25th, 2002, 05:49 PM	#9
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Yes, but have you tried opening a text file that is stored on your own hard drive in Excel? I get the feeling that this is a network problem and not a problem with Excel. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 10th, 2002, 01:52 PM	#1
sheiladt New Member Join Date: May 2002 Posts: 10	I was able to do this until I got a new computer running XP. Now I get an error message and a .csv file with no content is created. When I try to open it in WordPerfect or in Word, of course there's nothing to open. Is there another way to do this so I can get the .dat file for word processing?

May 10th, 2002, 03:54 PM	#3
sheiladt New Member Join Date: May 2002 Posts: 10	And, I should have added that I cannot open .txt and .csv files in Excel, either.

Jun 25th, 2002, 10:55 AM	#4
sheiladt New Member Join Date: May 2002 Posts: 10	I'm doing it manually, file-save as.

Jun 25th, 2002, 12:40 PM	#6
sheiladt New Member Join Date: May 2002 Posts: 10	The Excel message is: "filename.txt" cannot be accessed. The file may be read-only or you may be trying to access a read-only location. Or, the server the document is stored on may not be responding.

Jun 25th, 2002, 05:16 PM	#8
sheiladt New Member Join Date: May 2002 Posts: 10	The file is on a network server, running Novell 4.2 The error message is the same whether I try to open a .txt file in Excel or try to save an .xls file as a .txt

Jun 26th, 2002, 11:54 AM	#10
sheiladt New Member Join Date: May 2002 Posts: 10	I tried using my local drive and find that I'm able to do just about everything I need to do. I'll present it as a network issue to our systems manager. Thank you very much for your assistance and for sharinig your knowledge.