Saving Text Tab Delimited

doritav · Apr 18th, 2002, 01:55 PM

I just created this file today using the Text Import Wizard. Even thought I click on Save, the Save As dialog box comes up. It says, "The file already exists. Do you want to replace the exising file?" I click Yes. Then it says, " may contain features that are not compatible with Text (Tab delimited). Do you want to keep the workbook in this format?" If I click No, then I have to say Yes to the next box, to save it, and then it brings me back to this same box where I started. Otherwise, if I say Yes, it saves it, but next time I still have all these boxes to deal with. I just want to save the file without a lot of dialog boxes to deal with. Can you help? Thank you!!

Mark W. · Apr 18th, 2002, 02:29 PM

You're inadvertantly saving your imported data back to disk as a tab delimited text file (.txt). That's why Excel is warning you that you're gonna loose formatting, formulas, etc. Just change the Save as type to .xls.

doritav · Apr 18th, 2002, 02:41 PM

Thank you!!!! I was putting an xls on the end, but it didn’t recognize it. In the Save As box, it has a dropdown for file type. When I selected Microsoft Excel Workbook (*.xls), it was OK!!!!

Tron57 · Mar 29th, 2004, 04:15 PM

is there a way to make this automated. I have a file that comes in "Microsoft Excel 5.0/95 Workbook". its modified by macros that merge and do various other formatting. The formatting will be lost if the user does not chose "Microsoft Excel Workbook" as the save as type... and many times the user is lazy.... is there a way to make the save as type change via a macro?

Smitty · Mar 29th, 2004, 04:43 PM

Look at the Save As Method in the VBA help file & follow the link to File Format.

You can put the Save routine that you need in a Workbook_BeforeClose(Cancel As Boolean) event to automate the save process.

HTH,

Smitty

Mar 29th, 2004, 04:15 PM	#4
Tron57 Board Regular Join Date: Sep 2002 Posts: 66	Re: Saving Text Tab Delimited is there a way to make this automated. I have a file that comes in "Microsoft Excel 5.0/95 Workbook". its modified by macros that merge and do various other formatting. The formatting will be lost if the user does not chose "Microsoft Excel Workbook" as the save as type... and many times the user is lazy.... is there a way to make the save as type change via a macro?

Mar 29th, 2004, 04:43 PM	#5
Smitty MrExcel MVP Moderator Join Date: May 2003 Location: Boulder Creek, CA Posts: 23,704	Re: Saving Text Tab Delimited Look at the Save As Method in the VBA help file & follow the link to File Format. You can put the Save routine that you need in a Workbook_BeforeClose(Cancel As Boolean) event to automate the save process. HTH, Smitty

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

Apr 18th, 2002, 01:55 PM	#1
doritav New Member Join Date: Apr 2002 Posts: 2	I just created this file today using the Text Import Wizard. Even thought I click on Save, the Save As dialog box comes up. It says, "The file already exists. Do you want to replace the exising file?" I click Yes. Then it says, " may contain features that are not compatible with Text (Tab delimited). Do you want to keep the workbook in this format?" If I click No, then I have to say Yes to the next box, to save it, and then it brings me back to this same box where I started. Otherwise, if I say Yes, it saves it, but next time I still have all these boxes to deal with. I just want to save the file without a lot of dialog boxes to deal with. Can you help? Thank you!!

Apr 18th, 2002, 02:29 PM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	You're inadvertantly saving your imported data back to disk as a tab delimited text file (.txt). That's why Excel is warning you that you're gonna loose formatting, formulas, etc. Just change the Save as type to .xls.

Apr 18th, 2002, 02:41 PM	#3
doritav New Member Join Date: Apr 2002 Posts: 2	Thank you!!!! I was putting an xls on the end, but it didn’t recognize it. In the Save As box, it has a dropdown for file type. When I selected Microsoft Excel Workbook (*.xls), it was OK!!!!