export range to a txt or csv file??

[peach255]

How can I export only Column A & B of this worksheet to a
txt or .csv file?

I have the following code so far, and it is not working:
Set ExpRange = Columns("A:B&quot
ExpRange.Select
With CSVFile
.ExportRange = ActiveCell.RangeSelection
.Export CSVFilename:="C:\textfile.csv"
End With

thank you!

 

[SkipVought]

Hi,

1. copy columns to new workbook
2. "save as" new workbook



Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[peach255]

Thanks for your help. However, I prefer not to do "Save as" b/c then this would rename the current file open and cause some confusion. I would like to just export the Columns A & B to a txt file. Is there a way to do this? thanks!

 

[SkipVought]

This woud NOT rename the current workbook!

AGAIN...

1. copy columns to new workbook
2. "save as" new workbook

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com