Export Excel to Notepad

hgg_21 · Apr 26th, 2002, 03:27 AM

Hi,

I need to export a worksheet in a workbook into a CSV type of file or notepad.

Can I know the method?

THanks!

Colo · Apr 26th, 2002, 03:35 AM

Hi. Like this?

ActiveWorkbook.SaveAs "sample.txt", FileFormat:=xlCSV

hgg_21 · Apr 26th, 2002, 03:46 AM

Hi,

thanks for your help.
Issit possible is i want it to be tab delimited??

regards

Quote:

On 2002-04-26 02:35, Colo wrote:
Hi. Like this?

ActiveWorkbook.SaveAs "sample.txt", FileFormat:=xlCSV

Colo · Apr 26th, 2002, 03:52 AM

Hello again. Only change following.
FileFormat:=xlText

Regards,
Colo

hgg_21 · Apr 26th, 2002, 03:53 AM

hi Colo

thanks again!

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

Apr 26th, 2002, 03:27 AM	#1
hgg_21 New Member Join Date: Apr 2002 Location: Singapore Posts: 17	Hi, I need to export a worksheet in a workbook into a CSV type of file or notepad. Can I know the method? THanks!

Apr 26th, 2002, 03:35 AM	#2
Colo MrExcel MVP Join Date: Mar 2002 Location: Kobe, Japan Posts: 1,420	Hi. Like this? ActiveWorkbook.SaveAs "sample.txt", FileFormat:=xlCSV

Apr 26th, 2002, 03:52 AM	#4
Colo MrExcel MVP Join Date: Mar 2002 Location: Kobe, Japan Posts: 1,420	Hello again. Only change following. FileFormat:=xlText Regards, Colo

Apr 26th, 2002, 03:53 AM	#5
hgg_21 New Member Join Date: Apr 2002 Location: Singapore Posts: 17	hi Colo thanks again!