Copy Excel into a text file

[FAM]

I currently have a excel file which has just 1 sheet & this sheet contains 3 columns of data (A1:C2000) and two graphs.
I would like to create a macro which copys the 3 columns into a text file, which then prompts the user for a name & location (ie Save As) and then closes the file after the name is chosen.

Thanks in Advance

 

[SkipVought]

Hi,

You could simply Save As a .txt or .prn file in the Save as dialog. Record it and you've got you a macro.

VOLA!

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[FAM]

The thing is, i need a prompt to ask the user for a name and location as it will keep saving it to the same place with the same name.
If i try and save it, it keeps coming up with the information message that it may have features which are incompatible with txt files (ie the Charts).